dbTalk Databases Forums  

retrieving column name from ErrorColumn ?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss retrieving column name from ErrorColumn ? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nico Verheire
 
Posts: n/a

Default 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 !

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.