Post reply

Caprturing Error Message for components in SSIS

  • July 12, 2010 at 10:59 pm

    #221202

    Please help me out on how to capture detailed error message for any component in SSIS and store it to a variable. :unsure:

  • July 13, 2010 at 7:28 am

    #1192020

    I woruld suggest you create checkpoint xml file and parse the content

    :-):-):-)

    Raunak J

  • July 13, 2010 at 7:31 am

    #1192023

    In my environment, I write the SSIS event information to a log table, so I have not had to capture it as you are asking. However, it appears to me that you would use the Event Handler tab in SSIS and use a Script Task to capture OnError information and save to a variable.

  • July 13, 2010 at 12:34 pm

    #1192276

    you can capture the error message with system variable ...System::ErrorDescrition

    This variable will hold the actual error message when any error occured.

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

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