Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Transaction Handling

Author  Topic  vk59 Starting Member 38 Posts Posted - 2005-06-26 : 07:14:02 I have DTS Package in VBScript with multiple tasks to move data from source tables destination tables.There is any property in Package object to rollback the entire package, if any one of the task fails. I should ensure that either all of them will complete successfully or will roll back to the original state, if any one fails. Thanks In advance VK59 `