Execute DTS package from SQL

[LonnieJohnson]

Can you execute a DTS package from transact SQL.

What I am trying to do is send a command via an Access pass through query.

Can I do that?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[JayKusch]

Here is a method!

Presuming you have already created your DTS package, create a job by right clicking the package name and scheduling it. It will then create a job in the Jobs section of Enterprise Manager.

Edit the job and disable it. That way it will not run unless you manually execute it ... which we will do in the next step.

Now ... to execute the job we can submit the following command:

EXEC MSDB..sp_start_job @job_name = 'MyDTSPackageJobName'

Of course, change 'MyDTSPackageJobName' to the name of the job you created from your DTS package.

Thanks

J. Kusch