retrieving column name from ErrorColumn ? -
02-10-2006
, 06:30 AM
Hello,
does anyone have a clue on how to find the name of the column which caused
an error in a Data Flow Task?
I have a simple Data Conversion transformation, which converts some strings
to integers. Errors are routed to the error output, which adds the ErrorCode
and ErrorColumn fields.
Getting an error description from the ErrorCode is fairly simple.
But how to retrieve the column name that belongs to "ErrorColumn" ??
Now it says "31", which is not very helpful...
In design-modus I can retrieve the column (by searching the advanced
properties of the transformation).
But how to do this at run time??
Any help would be very much appreciated ! |