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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-01 : 08:22:24
|
| Frankie writes "Hi:I'm using DTS in SQL 2000 to import text data into a table and then get the DTS to send an email on success. Is there an easier way of adding the number of records to that email?I'm currently running a seperate DTS to write the number of records to a text file and then attaching the text file to the email.ThanksFL" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-01 : 12:52:56
|
| Why don't you just run xp_sendmail with a query in your DTS package? Do not use the e-mail object, use the Execute SQL Task object.Tara |
 |
|
|
|
|
|
Use Email Service to send Numberof records imported