Anand MR

Anand MR

  • NA
  • 39
  • 19.9k

How to get Flat File Error column Name in SSIS Packages

Jun 11 2015 12:06 AM
Hi Friends,
 
                   I am using CSV file for uploading data  into database.I use Data Conversion control in DataFlow task.If conversion failed i can able to get the error code only. I am not able to get the Error Column name. 
 
I tried the below article to get the error column name. In Step 4. need to add derived column (The value of this column will be the name of Data Flow it is in.)
here i didn't  get the point..How to set the derived column  value to name of Data Flow task..
 
http://sqlage.blogspot.in/2013/12/ssis-how-to-get-error-column-name-in.html 
 
Please anyone help me to get the error column name.If you have any source code please attache for me... 
 
 
Very urgent...
 
Thanks