-
Can I call a DTS package from an SP??
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
-
Can I call a DTS package from an SP?? (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|