September 10, 2008 at 7:57 pm
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 [/font]
September 10, 2008 at 8:10 pm
This post may help: http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx
December 24, 2013 at 11:29 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy