Best Practice Error Handling in SSIS? RRS feed

  • Question

  • I have some OLE-DB tasks tasks in some packages and I want to implement a generic error handling. I do not want to use the error output for each task for error handling but to bundle all errors from a package with one handler and write them to a log table. To easily locate the error sources afterwards I will need to include informations like the task name and table name and record name of the error source. Any best practices to do this in SSIS?
    Greetings from No Planet!
    Wednesday, September 28, 2011 12:24 PM


All replies