Friday, March 30, 2012

How to execute a DTS Package from inside a job

Good day!

Just wanted to ask how can I execute a DTS package from inside a scheduled job.

I have 3 DTS Package, so instead of scheduling the 3 package separately...I created a job to execute the 3 packages in a single scheduled time.

My syntax inside the command window is:
EXEC DTSPackageName

But its not working.
Any help is greatly appreciated.
Thanks.you can rightclick the package and schedule it.

or go to run --> dtsrunui --> advanced and generate the code to be put into the SQL Job. Do this for each package and then just copy and paste each of the code into the job steps.|||Hi!

I just did what you instructed me. But a syntax error occurred.
This is what i've pasted in the job step.

DTSRun /S "SQL2K-VBP" /N "FFPJLC_TO_CMS" /G "{7DE00045-4E3C-445D-A0B7-BA95370EB072}" /W "0" /E

Thanks for taking the time to answer my questions.

God bless. :)|||the job step is operating system command

run the dtsrunui and schedule the package, it will create the job automatically with the package you choose. then look into the job step to see how it is coded.|||DTSRun /S "SQL2K-VBP" /N "FFPJLC_TO_CMS" /G "{7DE00045-4E3C-445D-A0B7-BA95370EB072}" /W "0" /E

God bless. :)
Look up DTSRun in Books OnLine. When you set up the job step, make it an "operating system command". Here is an example (/E means trusted login
i.e. Windows authentication):

DTSRun /S ServerName /N "DTS Job Name" /E|||Hi!

Thank you so much guys for helping me out about this DTS Package scheduling. The job is working well now.

God bless. :) ;)

No comments:

Post a Comment