Trapping Errors in DTS (7.0)

• rustroot1

  Mr or Mrs. 500

  Points: 560

  More actions

  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

• philcart

  SSC-Forever

  Points: 47796

  More actions

  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