"artzoop@hotmail.com" wrote:

> 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
>