Hi,

I am trying to run a DTS package from my SQL server command line using
DTSrun.exe. I cannot get the syntax right to find the package, for I
keep getting "The specified DTS package ... does not exist".

Here is the command I'm using:
C:\Program Files\Microsoft SQL Server\80\Tools\binn>Dtsrun.exe /S
MyServer /N
"MyPackage" /W "0" /E
(...substituting MyServer and MyPackage names appropriately). The
package is located on MyServer (Integration Services 9.0...) -> Stored
Packages -> MSDB -> MyServer -> DTS Packages -> MyPackage. I have
tried numerous paths, but cannot get it to work, eg,

C:\Program Files\Microsoft SQL Server\80\Tools\binn>Dtsrun.exe /S
MyServer /N
"MyServer/Stored Packages/MSDB/MyServer/DTS Packages/MyPackage" /W
"0" /E
.... and all variations, marching down the "folder" structure (eg,
Stored Packages/MSDB/MyServer/DTS Packages/MyPackage, MSDB/MyServer/DTS
Packages/MyPackage, etc) . . . as well as flipping the forward slash to
backslashes.

In SSIS I have also saved a copy of the package in a file location and
then tried variations on finding that with DTSrun. . .

C:\Program Files\Microsoft SQL Server\80\Tools\binn>Dtsrun.exe /S
MyServer /N
E:\MIPweb\MyPackage /W "0" /E

Any suggestions are much appreciated.
Thank you!

Greg

You are using the wrong commandline. You should be using dtexec.exe as you
are trying to execute a 2005 package. Dtsrun.exe was for DTS. The name of the
technology in 2005 has changed from DTS to SSIS (SQL Server Integration
Services).

Try the following (Windows Integrated security is default):

Dtexec /SQL MyPackage /Server MyServer


Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk



"artzoop (AT) hotmail (DOT) com" wrote: