SQL Server Performance


Discussion in 'SQL Server DTS-Related Questions' started by sonijaiswal, Oct 30, 2007.

  1. sonijaiswal New Member

    1.How can we run multiple DTS packages in a single job.Please throw some ideas.
  2. thomas New Member

    Can anyone other than Satya answer, or just him?
  3. sonijaiswal New Member

    sorry , its open for everyone
  4. FrankKalis Moderator

    Just add as much job steps as you need and execute the package from the command line via xp_cmdshell and dtsrun. You might want to specify for each step how to proceed on success and error.
  5. Luis Martin Moderator

  6. satya Moderator

    [;)] LOL Tom....
    Refer to your own question before posting such duplicate posts, I have answered to similar post earlier.
  7. ranjitjain New Member

    Instead of Job, you can even create a Parent package and can call many child packages in it based on event failure, success or complete.

Share This Page