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 |
|
beaureef
Starting Member
2 Posts |
 Posted - 2007-10-17 : 11:24:04
|
| Hi,I have a DTS Package on a single SQL unclustered sever. The Package copies tables from database A to database A on another SQL unclustered server (they are identical). Then it runs robocopy locally on the first SQL server (C:\Program Files\Windows Resource Kits\Tools\robocopy.exe); an 'Execute Process Task'.I am now in a situation where I will be using 2 SQL Clusters (both active/passive). I have to recreate the DTS Package on Cluster1.1. Do I install the DTS Package to the virtual node on Cluster 1 or create it on both physical SQL nodes in Cluster 1?2. Do I need to install robocopy on both the SQL nodes in Cluster 1.3. In the DTS Package for the source and destination SQL servers do I enter the virtual node in cluster 1 and the virtual node in cluster 2, respectively?Very grateful for any help.Thanks, Mike |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 01:20:54
|
| 1. you create dts package in sql instance, not on physical node.2. you can put it on shared disk in the cluster.3. yes, use virtual sql server name. |
 |
|
|
beaureef
Starting Member
2 Posts |
Posted - 2007-10-30 : 04:45:32
|
| Thank You |
|
|
|
|
|
|
How do I create a DTS Package in a Cluster