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 |
|
kdyer
Yak Posting Veteran
53 Posts |
 Posted - 2005-01-07 : 20:10:51
|
Have a DTS package that works and has an e-mail component to let me know when it completes.However, the mail results from DTS appears limited in what it can send. I suppose I will have to go to CDO or something like that to attach the log results.It would be nice to have to have it e-mail me how many rows and tables were affected, results etc. from the process just run. Maybe like a start time, end time, etc. too. Thanks,Kent |
|
|
kdyer
Yak Posting Veteran
53 Posts |
Posted - 2005-01-12 : 14:44:51
|
| I figured out another way to do this and generate the rates/results while the package is being executed. The results are stored in a table and then use xp_sendmail with a SELECT to the rate table.Thanks,Kent |
 |
|
|
|
|
|
e-mail results from dts