HELP! with Error Handling

• Yavonka Hodges

  Newbie

  Points: 2

  More actions

  August 7, 2006 at 12:00 pm

  #113842

  Good Afternoon,

  I am a relative newbie to T-SQL and most of my experience so far has been trying to fix problems rather than develop.  I need to know the following:

  I am working with a DTS package that will not continue processing transactions after an error.  Can someone please tell me how to trap the errors but still be able to continue processing new transactions?

  Thanks from Sunshine Girl

• Leo Leong

  SSCommitted

  Points: 1615

  More actions

  August 7, 2006 at 9:05 pm

  #653761

  I thought DTS can allow you to specify what you want to do if failed?

  From the menu, choose WorkFlow --> On Failure

  Hope this help.

• Yavonka Hodges

  Newbie

  Points: 2

  More actions

  August 8, 2006 at 3:38 am

  #653787

  Leo,

  Thanks for the response, I will try it.

  Sunshine Girl