July 10, 2002 at 4:43 am
Hi all,
Just a quick question regarding DTS Connections.
When creating a SQL Server connection, should I be using the Server name or (local) in the "Server" field?
I have to split a SQL Server into two Servers now and our DTS's contain the Server name in the field. Obviously, I am going to have to change each DTS to the new Server name. Any quick ways of this or is it a manual job?
Also, any preferences of how I should be approaching this is always good to hear!
Also, correct me if I am wrong, but if you use (local), you can't debug on the client tools as EM will search your client machine for the database...is that right?
Thanks,
Clive Strong
July 10, 2002 at 11:11 am
As far as I know there is no quick way to change the connections in a DTS package. This will be a manual process.
I don't know, but think that your understanding of local would make it so you couldn't run the DTS package from client tools, you would have to log onto the server itself.
I prefer to hard code the name of the server into each connection and make changes when adding an additional server. This way I can run my DTS packages from any EM and get it to do exactly what I want it to do.
What I do is set up a DTS package that will perform transformations to one server. Then I make a copy of it (assuming all transformations and/or tasks must be the same for each server) and change the connections for the copy to the second server. Then I create a third DTS package that will execute the previous two DTS packages. This makes it easy to add as many servers as needed.
Hope some of this helps.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
July 11, 2002 at 2:18 am
Hey Robert,
Thanks for your feedback.
All of our servers are hardcoded with the Server Name. I was just playing about with the (local) parameter yesterday.
I like your idea of the 3 DTS's.
Thanks,
Clive Strong
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply