October 9, 2008 at 5:02 am
I have a SQL Agent job which uses DTSRun to invoke a DTS package, which in turn invokes a series of child DTS packages. I have script in the packages so I can pass parameters via the DTSRun command line. This was all fine on our old Win2K/SQL2000 single server. Now we have a super Win2K3/SQL2005 2-node cluster, I find that I need to specify a node name for the dts packages, not just the cluster name. That's fine when everything is running on the intended primary node, but during failover to the second node my dts configuration no longer works.
Is there a way to determine the active node and submit the appropriate DTSRun command line? Or persuade it to accept the cluster name not node name?
Longer-term obviously I will need to migrate away from DTS, but that's not going to happen this week, so I would appreciate some help with this.
October 9, 2008 at 7:44 am
I have several DTS packages running on the same sort of cluster environment (2k3 and sql 2k5) with no problems needing to specify the hostname instead of the virtual server name.
How are you invoking dtsrun?
Craig Outcalt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply