Post reply

Obtaining Error Description from ErrorCode and Column Name from ErrorColumn

  • March 20, 2007 at 5:07 pm

    #116261

    Hi,

    Can someone please shed some light on how I make the ErrorCode and ErrorColumn returned by SSIS more meaningful when handling DataFlow errors?

     

    Many thanks

     

    Jude

  • March 20, 2007 at 10:17 pm

    #696089

    Hi Jude,

    You can access the error description by passing the error code to the function GetErrorDescription (Pipeline.Wrapper.IDTAComponentMetaData90.ComponentMetaData.GetErrorDescription()).

    I use a script component transformation:

    Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)

    S. Hasse

  • March 21, 2007 at 3:42 pm

    #696270

    Thanks for the response Sean.

    I have since seen an example using the following line http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

    However I'm yet to get it to work properly.

    Do you know how to get the ErrorColumn to return a columnName rather than column ID?

     

    Regards

     

    Jude

  • April 2, 2007 at 11:11 pm

    #698215

    As far as I am aware, it is not yet possible but being considered for future releases.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply