DTS Commit/Rollback

[WIPWCB]

I am a newbie to this and have an important question. I plan on having a large DTS session involving over a 100 tables being transferred.

If there is a failure mid way through my batch run of the package, is there anyway that i can rollback all of the previous tables that have already run so that i can rerun the process? Or is there someway of just running certain Data Pumps(ones that fail)?

 

[ClaireHCM]

Usually in stored procedure we check error occurance by using @@error, if @@error <> 0, then issue rollback, but when DTS package has error occur, SQL Server immediately fail the package. Since the package is dealing 100 tables, the troubleshooting is going to be tough and difficult to maintain in the long run.