Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2007-09-20 : 00:30:54
|
| I have various SSIS packages running on my SQL Server 2005, they are mostly schadule to perform data updations from different locations over remote network. In every task there is an email object added in so that it can notify about sucessful completion of SSIS package.Here I want my email should contain some information about how many records updated in system ... or how long it take to complete the job.Can i include sort of information into email object? if yes ... then how to do it?ThanksMIZ |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-21 : 11:57:37
|
| There are different ways of accomplishing what you want, for instance if you want to send the number of rows transfered on a data flow, you can add a "Row Count" component between your source and destination on a data flow, write that number to an package integer variable and read that number into an email component using the expression language, it's really simple and there are a lot information available about the execution of the package for you, google "SSIS Expression Language". Your expression could look like something like this:(DT_WSTR, 10) @[User::RecordCount] + " Records loaded to Table_Staging for " + (DT_WSTR, 2) @[User::State] + " on SQLServer1Info: "+ @[System::PackageName] +" was executed at: " + (DT_WSTR, 40) @[System::StartTime] + " by user: " + @[System::UserName] + " on Machine: " + @[System::MachineName] |
 |
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2007-09-24 : 03:43:17
|
| Thanks a lot ... it works ...Can you please tell me in SQL Task how to use variables with parameters? and how to pass paremeter values through an ASP.NET page using VB.NeT |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-24 : 18:06:49
|
| This should be a very simple task too, create a variable, map it correctly and use it on your SQL Task. Now, I'm not an application person, so I wouldn't be able to help you with your second question, but I believe the links below might be able to help you.http://technet.microsoft.com/en-us/library/ms141003.aspxhttp://technet.microsoft.com/en-us/library/ms140355.aspx |
|
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2007-09-25 : 00:58:52
|
| Thx bro |
|
|
|
|
|
|
|
|
Customized Email