Hi,
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!
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
-
-
itit
Big Finger
the way i would do is
1. Connect to remote SQL server over the Internet
2. transfer the new data over from that server (as tmp tables)
3. once the data transfer is complete delete the original tables
4. rename the tmp tables. -
Maurits
AKA Matthew van Eerde
Have you considered publish/subscribe replication?
-
DCMonkey
What?!?
-
Transactiosns and temp tables my friend........persoanlly I think I would just go with transactions, but temp tables might be handy
-
I'll try the transactions, thanks!
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.