>Is there a way to call a DTS Package from another DTS Package. I am trying to use the DTSRUN /~N (name of package) but, I keep getting errors. So if the name of the package is "DTSTestPackage, I perform an Execute SQL Task and then type DTSRUN /~N DTSTestPackage and it doesn't like the '/' or the '~' and with some other kinds of formats I've tried it even gives me back, "Could Not find stored procedure DTSRUN." I don't know what I'm doing wrong.
Hi Greg,
The DTSRUN is a command prompt utility, so you might need to use something like xp_cmdshell, but you'll need to make sure of the permissions. You might also look into using OLE Automation object functions, like sp_OACreate, etc...
Hope this helps,
Phillip
Phillip Grant
Grant Computer Consulting
731.642.2162
phillip@grantcomputer.comBrainBench Certified: Visual FoxPro, RDBMS Concepts