Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Hassling with DTS Packages

Author  Topic 

PiecesOfEight
Posting Yak Master

200 Posts

Posted - 2001-03-22 : 18:47:23
I am trying to run a DTS package from QA, and thought xp_cmdshell would be the way to go. I have saved the package as a local package named DTS_DataDump, and have called xp_cmdshell with the params listed in BOL, but it says the specified package name doesn't exist. I thought with local packages I could just provide the name, but it doesn't seem to work...

EXEC master.dbo.xp_cmdshell 'DTSRUN /Sserver-ibm /Usa /P /N DTS_DataDump'

   

- Advertisement -