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 |
|
asmith1972
Starting Member
3 Posts |
 Posted - 2006-07-13 : 14:01:29
|
| HiWe have a failover type SQL 2000 cluster eg everything runs on server 1 and if that fails everying runs on server 2.Anyway everything runs fine expect our DTS packages. I think its because when we fail over to server 2 the code in the DTS package trys to run them on server 1.Does anyone know how to create a DS package that runs in the Virtual server name and not the servers Actual name?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-13 : 14:07:38
|
| The code should not be referring to the physical names of the nodes in the cluster. The code should be referring to the SQL Server name which is VirtualServerName (default instance) or VirtualServerName\InstanceName (named instance).So you need to find out what the virtual names are then put that in the DTS package.Tara Kizeraka tduggan |
 |
|
|
asmith1972
Starting Member
3 Posts |
Posted - 2006-07-13 : 14:13:24
|
Thank you, most of our packages were created on a standalone server, but have now been migrated to the cluster. Do you know what field I need to edit to point them to the virtual name? quote:
Originally posted by tkizer
The code should not be referring to the physical names of the nodes in the cluster. The code should be referring to the SQL Server name which is VirtualServerName (default instance) or VirtualServerName\InstanceName (named instance).So you need to find out what the virtual names are then put that in the DTS package.Tara Kizeraka tduggan
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-13 : 14:17:56
|
| I have no idea what your DTS package looks like, so I can't know what field to edit. You'll need to open up each task inside the package and modify if necessary.Tara Kizeraka tduggan |
|
|
|
|
|
|
DTS Package on a Cluster