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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-06 : 10:02:20
|
| Jennifer writes "How do I DTS data to an Identical DB, which resides on a different server - via the DTS mechanism?This is very urgent – any help would be most appreciatedThanks and RegardsJen" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-06 : 12:42:42
|
| You should be able to walk through the DTS Wizard in Enterprise Manager and do this. I send data back and forth between separate SQL Servers on a regular basis. You might need to setup the other server in your Client Network Utility. Then you can pick it from the drop down list in the wizard, or type it in, and all is well. If you are running into a specific error, we'll need to know the exact syntax of the error message to help.-------------------It's a SQL thing... |
 |
|
|
|
|
|
Data Transfer Services (DTS )