Home Forums Data Warehousing Integration Services Retrieving the Error Type in the Data Flow RE: Retrieving the Error Type in the Data Flow

  • February 7, 2018 at 9:37 am

    #1978923

    Phil Parkin - Wednesday, February 7, 2018 7:53 AM

    tim.ffitch 25252 - Wednesday, February 7, 2018 7:36 AM

    Phil Parkin - Tuesday, February 6, 2018 11:29 AM

    Which version of SSIS are you running? Things changed in 2016 to make this task easier.

    Funnily enough it is 2016. I have just begun to experiment with the OnError events and using a script task to see what information I can obtain from the error.

    What else do you have in mind?

    Thanks
    Tim.

    I was referring to the use of a Script Component (not Task) to retrieve Error Column Name and Error Column Description, as described here. It might help, if you need to be very granular.
    But I think that you are on the right track with your OnError research.

    Thanks for the info, I didn't know about that, it could prove very useful.