Can I call a DTS package from an SP??

[Don Cole]

Hi SQL Colleagues:

Is it possible for me to call a DTS package from within a stored procedure? If it is not possible to do so directly, would I at least be able to call the package through a job?

Thanks!!!
Don

[Ralf Griggel]

As far as i can see, you have two options here.
1.) Use the "OLE Automation Extended Stored Procedures" in order to open the DTS packet and start it or
2.) Use the "xp_cmdshell" in order to start the dts as a process. (nearly the same as starting a DTS from a Job)

Greetings,

Ralf


------------
Don Cole at 1/4/00 5:02:06 PM

Hi SQL Colleagues:

Is it possible for me to call a DTS package from within a stored procedure? If it is not possible to do so directly, would I at least be able to call the package through a job?

Thanks!!!
Don