January 11, 2006 at 9:01 am
I have created the package outlined in Lesson 5 of the ssis tutorial. I am routing failed rows to a text file, so in effect there are no failed tasks. However, I would like to send an email when any rows fail. Event handlers don't seem to do the trick. Any help would be greatly appreciated.
Terry
January 16, 2006 at 8:00 am
This was removed by the editor as SPAM
January 16, 2006 at 10:08 am
Place a rowcount transform between the error output and the destination adapter. Place a sendmail task in the workflow after the Dataflow task. Place an expression on the precedence constraint that checks if the rowcount variable is greater than zero. If it is, the sendmail task will execute, if not, no mail.
K
January 16, 2006 at 4:23 pm
Thank you Kirk. That worked out well. I really appreciate the help.
Terry
October 26, 2007 at 6:02 am
Terry, if possible Can you please send that Example on Error Handling which you were talking about.
Regards,
Mahesh
April 13, 2012 at 3:15 am
can you please share me the document or examples for sending an SSIS error logs through email
email: 222.rajkumar@gmail.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply