dbTalk Databases Forums  

ErrorColumn in SSIS data destination

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


Discuss ErrorColumn in SSIS data destination in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wilfried Mausz
 
Posts: n/a

Default ErrorColumn in SSIS data destination - 10-20-2005 , 01:49 AM






Hi!

I have written a SSIS data destination. There two extra columns "ErrorCode"
and "ErrorColumn" are availible. I can get the description of the error using
followig statement:

String errorDesc =
ComponentMetaData.GetErrorDescription(Convert.ToIn t32(buffer[ci.bufferIndex])).Trim(); // where ci.bufferIndex is the column containing the error code

But I can not get the name of the error column. Documentation tells it
should be a linageID, but the ID returned by ErrorColumn does not occur in my
linageIDs. Does anybody have an example for how the column name can be
retreived successfully?

Thanks for your help.

Bye, Wilfried

Reply With Quote
  #2  
Old   
Wilfried Mausz
 
Posts: n/a

Default RE: ErrorColumn in SSIS data destination - 10-20-2005 , 04:06 AM






Hi!

To be more accurate, I am dealing with a data component that is connected to
the error output of a OLEDB-destination. So I get ErrorCode and
ErrorDescription.
As far as I have seen the ErrorColumn value is the InputID of the original
data destonation (OLEDB destination) but not the LinageID, like it is written
in the documentation.

Is there a way to get the column name without having a proper linageID in my
own data destination? Shouldn't the ErrorColumn value be a linageID?

Thanks for your help.

Bye,

Wilfried

"Wilfried Mausz" wrote:

Quote:
Hi!

I have written a SSIS data destination. There two extra columns "ErrorCode"
and "ErrorColumn" are availible. I can get the description of the error using
followig statement:

String errorDesc =
ComponentMetaData.GetErrorDescription(Convert.ToIn t32(buffer[ci.bufferIndex])).Trim(); // where ci.bufferIndex is the column containing the error code

But I can not get the name of the error column. Documentation tells it
should be a linageID, but the ID returned by ErrorColumn does not occur in my
linageIDs. Does anybody have an example for how the column name can be
retreived successfully?

Thanks for your help.

Bye, Wilfried

Reply With Quote
  #3  
Old   
funkeymonkey (Offline)
Junior Member
 
Posts: 1
Join Date: Aug 2006

Angry error column - 08-10-2006 , 08:53 AM



Hi, I read your post, I also have the same requirement and its driving me mad !
Have you got anywhere with this ?
Thanks.

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.