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 DB
I 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 query
I wonder if the email have following info. :
ABC SSIS had been completed.
No. of row had been import from .xlsx file : XXXX
No. of row had been updated in ABC DB : XXX
No. 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
 |
|
|
|
|
|
send email task with logs of INSERT UPDATE DELETE