I have many servers with SQL Server 2000 installed. I have a DTS and I need to do that be dynamic. I need to configure a dynamic SQL Server Connection and call it by CmdExec (pass a parameters the servername to source and destination source).
Anyone can help me?
Answer by Leo ·
Here is how I use DTS in SQL 2000.
Let say there is DTS Package with 2 Servers connection,and add Dynamic properties Task. Before that Create the Global Variables First (for example - Server Name, Pwd, etc..). Then go back to Dynamic Pro Task and point it to those Global Variables inside the Dynamics Pro Task.
Then you can pass Global Variables from anywhere... Stored Procedure or other application by using (DTS Library - if you are using VB,C++, etc...)
Let me know how you get on.