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)
 DTS Rollback

Author  Topic 

Nprashar
Starting Member

1 Post

Posted - 2003-12-10 : 15:04:35
How do I rollback a DTS package?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-10 : 15:06:32
Do you mean go to the previously saved version? Or ROLLBACK the transaction?

If you want the previously saved version, then right click on your package in EM and go to version. Then select your version and go to edit. Then save it so that it becomes the current version.

If you want to ROLLBACK a transaction, then you would have had to specify ROLLBACK commands if an error occurred.

Tara
Go to Top of Page
   

- Advertisement -