recover failed dts packages

• shailendra-251422

  Ten Centuries

  Points: 1111

  More actions

  November 22, 2005 at 5:08 am

  #67656

  Hi,

  Does DTS 2000 have inbuilt recovery features? i.e. if a package that updates a target table fails after updating some rows, then i can fix the problem and restart the package.

  In the recovery mode, the package should not update the rows that were successful in the previous run, and should update only those that were left out due to the failure.

  What if the package updates more than one target, and both fail at different points?

  does DTS handle this on its own, do i have write custom code for this?

  All help will be appreciated, Thanks!

   

• Ananda Kumar

  SSCommitted

  Points: 1845

  More actions

  November 22, 2005 at 5:22 am

  #605192

  Hi,

  You can declare a global variable, and can assign some values if the process succfully done. While restarting you can compare the value.