SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 send email task with logs of INSERT UPDATE DELETE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mattluk
Starting Member

15 Posts

Posted - 09/29/2013 :  22:44:37  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 09/30/2013 :  08:53:07  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000