DTS Question
-
I successfully created a DTS package and savinging it in a Structured Storage File (.dts). I am successful a runing this package with the dtsrun command from a Windows command prompt (ie: dtsrun /E /F
/N ). I have not been successful at running the dtsrun command when specifying the dtsrun server parameter (ie: dtsrun /S /E /F /N ). I have tried using before and after double quotations (") on the instance, fileneme, and packagename. I have Windows 2000 SP4 and SQL Server 2000 Standard Edition SP3 and SP4. Can someone explain why DTSRun /S does not work or is it designed not to use /S when using /F? -
What are you trying to achieve by specifying both /S and /F?
From Books Online,
/F filename
Is the name of a structured storage file containing DTS packages. If server_name is also specified, the DTS package retrieved from SQL Server is executed and that package is added to the structured storage engine.
--------------------
Colt 45 - the original point and click interface
-
I was thinking /S would run my package on whatever server I labeled after /S. If I understand correctly, one cannot use the dtsrun.exe on one server to execute a package saved in a file against a different server, correct? In otherwords, if I have dtsrun.exe on server A and my DTS package has been saved in a file on server A, is there a way to use server A's dtsrun.exe to execute the package in server A's file against a database on Server B?
-
Running the package against a different server/database has nothing to do with the startup parameters. These are used for determining the location of the package.
To run the package against a different server/database you need to change the connections within the package itself.
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply