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.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-02-01 : 12:39:03
|
| I've got 2 SQL2K databases on 2 different servers. One of the databases is an internally used DB and the other a backend for a website.I need to get the data from the internal one to the web one.Various tables in the internal one have fields in them to indicate if the record needs inserting or updating. We are not actually deleting records only hiding them by setting a bit field.I think i need to put together an Execute SQL Task DTS package to connect between the two and perform the various updates or inserts on the web DB depending on the settings of the flag/bit fields in the internal DB.Am i on the right path or is there a better solution ?How hard is this to do ?thanks |
|
|
|
|
|
DTS Inserts, Updates, Deletes