HOw to retrieve error column name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » HOw to retrieve error column name

HOw to retrieve error column name

Rate Topic

Display Mode

Topic Options

Author

Message

Learner1

Posted Wednesday, September 10, 2008 7:57 PM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:02 PM
Points: 323, Visits: 804

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

Paul_J

Posted Wednesday, September 10, 2008 8:10 PM

SSC-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

« Prev Topic | Next Topic »

Permissions