get error column name in error handling

• SSIS_DEV

  SSC Enthusiast

  Points: 159

  More actions

  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?

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  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

• SSIS_DEV

  SSC Enthusiast

  Points: 159

  More actions

  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.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 6, 2010 at 2:09 pm

  #1189320

  You are very welcome.

  CEWII

• aamir.nmhu

  SSC Enthusiast

  Points: 108

  More actions

  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