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