Can I invoke a DTS Pkg via a SQL SP

[Guest_imported]

Is it possible to start a DTS package from a SQL Stored Procedure? If so, do you have sample code for this invocation?

thx-
BT

 

[RickCole]

Have a look at the following link:

http://www.sqldts.com/main.asp?nav=1,6,210,0

This should give you the details you want.

Rick.

 

[fluteplr]

There is another way that is not mentioned in that link (or at least I did not notice it).

You can right click on the dts package and create a job. Remove the schedule from the job and then use sp_start_job to run the job as needed. There are some security issues with this that are described fairly well in BOL docs for sp_start_job.