capturing Error Column

• MajikTom

  SSC Journeyman

  Points: 92

  More actions

  October 1, 2011 at 9:48 pm

  #1389179

  Try this, works great:

  MSSQL2008:

  http://sqlblogcasts.com/files/folders/transforms/entry11865.aspx

  MSSQL older:

  http://sqlblogcasts.com/files/3/transforms/entry2.aspx

  😉

• aamir.nmhu

  SSC Enthusiast

  Points: 108

  More actions

  December 24, 2013 at 11:37 pm

  #1675871

  Hi,

  Here is step by step approach how to get Error Column Name by using LineageIDs.

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

  Thank you

  Aamir