How to find the error column name in SSIS?

• prakashr.r7

  SSCrazy

  Points: 2828

  More actions

  September 6, 2013 at 3:21 am

  #282150

  Hi Friends,

  I am trying to capture the error coulmn which caused to stop the process. When i googled , i came to know about to catch the error description but not able to get any clear idea of catching the error column. What i understood is there are only two ways that we can do 1. Third party tool 2. our own coding in scrip component.

  I am bad in writing scripts. So could any one help me how to handle this? It would be very grateful.

  Thanks in advance for your suggestions.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  September 6, 2013 at 3:29 am

  #1647972

  This article explains how you can do it:

  http://bennyaustin.wordpress.com/2011/02/04/ssis-name-of-errorcolumn/

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• k.karthik0889

  SSC Journeyman

  Points: 99

  More actions

  November 19, 2018 at 2:04 am

  #2013931

  Please refer the below article 
  https://www.sqlservercentral.com/Forums/2007173/Get-the-Error-Column-Name-in-SSIS