handling errors in SSIS 2008


  • Hi everyone

    I'm working with SQLServer Integration Service 2008

    I have some questions about handling fails in SSIS:

    I have a package containing a data flow task, wich has some data flow sources, transformation, and destination, but without handling error the task stops displaying the error cause in the output window, the error message is very clear, like this: Hresult: 0x80004005 Description: "Violation of UNIQUE KEY constraint ...."

    When I try to handle the fails for logging messages, I try to capture manipulating "Oledb destination error output" looking for that error, but that message is hidden and always returns this ErrorCode -1071607685 with the message "Not status is available", and the columnNumber is 0. That is the same for any sql server error occurs.

    I need to capture sql server errors from ssis package, code and message, not ssis package errors, this is for logging that messages in a database.

    Thanks for any suggestion.

    Jose Obregon
    Saturday, July 13, 2013 4:05 PM


All replies