February 21, 2016 at 2:32 pm
I am trying to retrieve the error column name information on redirected error rows at an OLEDB destination component.
SSIS providing only Errorcode and ErrorColumn information.
I get the value of the ErrorColumn integer is also the LineageID, but I'm not sure how to use that to get the Error Column Name.
I've search google and can't seem to find an answer or script for this.
Is there an updated method to finding this out?
February 22, 2016 at 4:04 pm
Why do you need that information? Sometimes, just thinking about the why can provide the impetus for developing an alternative.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
February 22, 2016 at 6:11 pm
No need, just thought I could learn how to do it through scripts or making a custom component. Excuse my noobness
February 22, 2016 at 9:49 pm
No problem... I often try to help by asking questions that might provoke a different way of thinking about the problem, ... especially when I don't know the answer, and like you, couldn't find any useful info on the net. Never be afraid of being a noob, or you'll never get anywhere... you have to start somewhere, after all.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply