Script Component: Capture Column Header/Name and/or Value fo Field that caused Error

• teekay-101299

  Mr or Mrs. 500

  Points: 585

  More actions

  March 3, 2008 at 8:37 am

  #122478

  I have a process that imports data from a flat file to SQL 2005 table. When an error is encountered, I am redirecting the row to a Script Component.

  In the Script Component, I would like to capture the column name/header in which the error occurred AND/OR the value of the field that caused the error.

  Any recommendations are appreciated.

  Thank you,

  TeeKay

• Jay1234

  SSCommitted

  Points: 1624

  More actions

  March 3, 2008 at 9:02 am

  #784485

  I had same issue before. Looks like getting error column is not at all easy. Read this for more:

  http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx#bm457730