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 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 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy