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 |
|
mattluk
Starting Member
15 Posts |
 Posted - 2013-09-29 : 22:44:37
|
I use SSIS to import the .xlsx file into DBI have somm INSERT UPDATE and DELETE query in SSIS,finally will send the email to me, to tell me the jobs had been done.But I don't know how to send the logs of INSERT UPDATE and DELETE queryI wonder if the email have following info. :ABC SSIS had been completed.No. of row had been import from .xlsx file : XXXXNo. of row had been updated in ABC DB : XXXNo. of row had been deleted in ABC DB : XXX |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-09-30 : 08:53:07
|
| use RowCount transformation in data flow task to capture the insert,update and delete counts.If using execute sql task use @@ROWCOUNT to capture affected record count for each of the operations and store it in SSIS variables to fetch and siplay in email task------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
send email task with logs of INSERT UPDATE DELETE