error handling in ssis RRS feed

  • Question

  • how i do error handling in ssis
    Friday, July 29, 2011 7:54 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.

    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