Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: 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.

  2. #2
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144
    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.

  3. #3
    Join Date
    Oct 2005
    Posts
    119
    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.

  4. #4
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by LimaCharlie

    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

    -- This is all just a Figment of my Imagination --

  6. #6
    Join Date
    Oct 2005
    Posts
    119
    Hi!

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

    God bless.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •