To the Anonymous User, you should use global variables to set all values that are going to change when you move the package. Then, you simply have to update the global variables to whenever/wherever you move it.

Anonymous User 11/3/2004 3:02:11 PM

I want to create a DTS package in the development SQL Server and move it to Production SQL Server later. How can i change the SQL Server Name, Source and Destination names used in the package with out much intervention from the Production DB Administrator.? Is there any way I can create some scripts like SQL Stored Procedure and edit it later.

Anonymous User 10/27/2004 7:32:13 AM

This article is very usefull for me. Thanks

Rohan Perera 6/5/2004 11:59:14 PM

Hi

I'm searching the web to try and find any information on the 'Parameters' value in DTS package task 'Execute Process.

So far I havent' found much, the batch job I'm calling from DTS is failing and so is my knowledge..!

Cheers

Richard Burton 10/17/2003 6:12:39 AM

Hi

I have been trying for quite sometime now, to execute a DTS Package saved on my server under Local packages, from the command prompt using a batch file. It doesn't execute. It opensup a separate window but it doesn't execute. The syntax i had used to get it executed is as follows

cmd /c \\\\abcdefghi\\MSSQL7\\binn\\dtsrun /S abcdefghi /E /N P1

I had tried all combinations of flags for instance , saving it as a file and running and using USERID etc. But it doesn't seem to work.

The server configuration we have is as follows..
It's a Winnt CLUSTER of 2 servers , which i am accessing through their virtual Names. Some one told me that you cannot invoke the DTCRUN application on a virtual server. If this is true how do you schedule the package. Please help.

Sambasiva Darbha 6/26/2001 1:46:17 AM