HOw to retrieve error column name

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  September 10, 2008 at 7:57 pm

  #131185

  i am trying to retrieve error column name information on redirection of error rows at OLEDB destination component.

  On re-direction .............SSIS is providing only Errorcode and ErrorColumn information.

  The value in the ErrorColumn is an integer which refers to a ID in the metadata.

  require a logic to translate the ID to appropriate column name from with in the package.

  any help on this

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  September 10, 2008 at 8:10 pm

  #870079

  This post may help: http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx

• aamir.nmhu

  SSC Enthusiast

  Points: 108

  More actions

  December 24, 2013 at 11:29 pm

  #1675869

  Hi,

  Here is step by step approach how to get Error Column Name for redirected rows

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

  Thank you

  Aamir