I have a DTS package (sql server 2000 at the moment, but could be migrated to 2005), that basically does the following:
- drop local tables / data
- connect to remote SQL server over the Internet
- transfer the new data over from that server
Now, the problem is simple: in the first step all the local data is deleted, but if consequently the connection to the remote server fails, the users are left with no data!!!
So how it SHOULD work is that the drop tables are ONLY executed IF the connection succeeds!
What's the easiest way to accomplish this?
Thanks for your suggestions!