Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: Schedule DTS Packages to run sequentially

    Hi,

    I have eight DTS packages. I would like to schedule all of time to run every night. Can I do this in sequence like something similar to scheduling "Job" in SQL Server Agent, when package one finish, immediately execute package two, then package three...and so on.

    Any ideas? Thanks in advance.

    Snoopy

  2. #2
    Join Date
    Aug 2003
    Posts
    39
    Create a job, each step in the job can be the next package.

    Step1 = Package1
    Step2 = Package2
    ect......

  3. #3
    Join Date
    Jan 2004
    Posts
    21
    SHICKS:
    Thanks. Can you tell me how to do it? Can I do it through SQL Server Agent?
    When I go to SQL Agent -> New Job -> steps -> New Job steps, I don't know where to specify my package. Or should I do in by other methods? Thanks in advance.

  4. #4
    Join Date
    Jan 2004
    Location
    Ottawa, Canada
    Posts
    53
    If you are using SQL 2000 Client you can define a dts Package Run object at the end of each DTS Package.

    SQL 7 CLient does not have this functionality

Posting Permissions

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