Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HOw to retrieve error column name Expand / Collapse
Author
Message
Posted Wednesday, September 10, 2008 7:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866

i am trying to retrieve error column name information on redirection of error rows at OLEDB destination component.

On re-direction .............SSIS is providing only Errorcode and ErrorColumn information.

The value in the ErrorColumn is an integer which refers to a ID in the metadata.

require a logic to translate the ID to appropriate column name from with in the package.

any help on this



---------------------------------------------------

Thanks
Post #567426
Posted Wednesday, September 10, 2008 8:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 17, 2010 5:56 PM
Points: 185, Visits: 637
This post may help: http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx
Post #567431
Posted Tuesday, December 24, 2013 11:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:04 PM
Points: 8, Visits: 330
Hi,
Here is step by step approach how to get Error Column Name for redirected rows

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

Thank you
Aamir
Post #1525860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse