Answered by:
error handling in ssis

Question
-
how i do error handling in ssisFriday, July 29, 2011 7:54 PM
Answers
-
what is the use of error handling?
you can use error handling for custom logging, or for any action you want to do based on an event,
for example you want to send an email when one of the tasks in control flow cause error, so you create an OnError event handler, and add a send mail task there. or you want to do a task when a variable value changes, so you can use OnVaraibleValueChanged variable. a sample of custom logging with event handlers is in Deepak's post.
http://www.rad.pasfu.com
My Submitted sessions at sqlbits.com- Marked as answer by Naresh_a Friday, August 5, 2011 6:41 PM
Saturday, July 30, 2011 6:55 PM
All replies
-
-
how we achieve error handling in ssisFriday, July 29, 2011 8:13 PM
-
Error handling is SSIS can be inbuilt or customized.
1) Inbuilt SSIS has error codes and messages which can be logged in the data flow or throuigh the event handlers.
2) Cutomized error handling through the use of event handlers can be performed as per Jamie's blog http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!Friday, July 29, 2011 8:14 PM -
what is the use of error handling?Saturday, July 30, 2011 6:25 PM
-
what is the use of error handling?
you can use error handling for custom logging, or for any action you want to do based on an event,
for example you want to send an email when one of the tasks in control flow cause error, so you create an OnError event handler, and add a send mail task there. or you want to do a task when a variable value changes, so you can use OnVaraibleValueChanged variable. a sample of custom logging with event handlers is in Deepak's post.
http://www.rad.pasfu.com
My Submitted sessions at sqlbits.com- Marked as answer by Naresh_a Friday, August 5, 2011 6:41 PM
Saturday, July 30, 2011 6:55 PM