Post reply

Trapping Errors in DTS (7.0)

  • June 25, 2003 at 8:15 am

    #159335

    Hello fellow board browsers,

    I was wondering if there was a way to trap an error from a step(s) within a DTS package. I know you can setup a workflow failure task to handle errors, but what if I want to store the exact error message in a table within the database? SQL 2k has this ability, but I am using 7.0 sp 4. Ideally, I would like to setup a workflow failure task that would insert the exact error into a table. Is there a way to trap this?

    Thanks in advance,

    Rusty

  • June 30, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • July 1, 2003 at 6:03 am

    #463749

    With SQL 7, probably your best bet is to turn on the logging, which will log the messages to a file. Then on failure pickup the file that is created and parse it for the error.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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