Post reply

get error column name in error handling

  • June 29, 2010 at 7:34 am

    #145751

    Hi,

    Anybody can tell how to get column name where error is occurred. I am checking datatype mismatch and error rows are redirected to a user created table from which reports are to be generated.(Thanks to Mr. Jack Corbett for his article regarding error handling)......

    I want to retrieve column name from error outputs. But I read that column names cannot be generated using their lineage IDs.

    So what can be the solution for this problem?

  • June 29, 2010 at 2:56 pm

    #1186712

    I think you can actually look at the DTSX file and find them but it is a hassle.

    There is a component on CodePlex that will do this for you:

    http://eod.codeplex.com/

    CEWII

  • June 30, 2010 at 2:47 am

    #1186923

    Sir,

    Thanks a lot for your kind help. I followed the link mentioned by you and I got the result more than I wanted.

    Thank you once again.

  • July 6, 2010 at 2:09 pm

    #1189320

    You are very welcome.

    CEWII

  • December 24, 2013 at 11:34 pm

    #1675870

    Hi,

    By using Script component and read the package file itself, Error Column Name can be read.

    Here is step by step approach

    http://sqlage.blogspot.com/2013/12/ssis-how-to-get-error-column-name-in.html

    thank you

    Aamir

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply