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
 Import/Export (DTS) and Replication (2000)
 Run DTS package

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2004-01-16 : 17:33:49
"I have a Stored procedure tha call a DTS package using dtsrun
ie
exec master..xp_cmdshell 'dtsrun /SsqlSERVER\Instance /Usa /Ppassword /Nget_spscripts /Agv_campid="C1"'
when run on the Production server I get the following error

Error string: The specified DTS Package ('Name = 'M001 sp_dets'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

but whe run on other severs it works OK

Any ideas what to check for
"





tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-16 : 17:43:40
Same service pack on the servers?

Tara
Go to Top of Page
   

- Advertisement -