Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SSIS
How we can Get Error Column Name in SSIS Package.
 
In my case i am using Data Conversion transformation and i am redirecting error output to Script component.
I need to log error output with the columName which cause the error.
 
Please help me if you face this issue and resolved successfully....
 
Thanks,
Amarnath
Posted 14-Aug-12 8:38am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You get the rows causing the errors dumped out the error output. Each row will have a new "ErrorColumn" column - for the rows that you're interested in, record the value you see in that column. That value is the "lineage ID" of the incoming column that suffered the reported error.
 
You may use advanced editor to find the column that has lineage ID...
But to find this programmatically needs some circus:
 
http://informatics.northwestern.edu/blog/edw/2012/01/etl-assistant-getting-error-row-description-and-column-dynamically/[^]
 
Thanks,
 
Kuthuparakkal
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Can you use the name of InputColumn?
such like:
this.ComponentMetaData.InputCollection[0].InputColumnCollection[0].Name
Hope this will help you.
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

I builded new custom transformation component for read Error Column name using Error column value.You can get DLL and source code from the below link
 
https://naseermuhammed.wordpress.com/tips-tricks/getting-error-column-name-in-ssis/[^]
 
Thanks
Naseer Muhammed AG
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 6,775
1 OriginalGriff 6,696
2 CPallini 5,345
3 George Jonsson 3,599
4 Gihan Liyanage 2,751


Advertise | Privacy | Mobile
Web02 | 2.8.140922.1 | Last Updated 28 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100