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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 send email task with logs of INSERT UPDATE DELETE

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
Go to Top of Page
   

- Advertisement -