General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Rollback a DTS-package
We run several DTS-packages on an SQL server 2000 during the night.
Each package updates several tables by first dropping them, then creating new instances and finally copying the data from the source into them.
The problem is that the connection to the source is established after the drop and the creation. So, when this connection can't be established, the new tables contain 0 records.
Can somebody tell me how I can rollback the package or how I can test on the connection the source prior to the drop and creation and cancel the package if the connection fails.