Stored proc script calling DTS packages sequentially one after another by using cursors

  • Is there any way to change the stored procedure to run the DTS packages parallel.

    Please help

  • Not sure what you are asking, but if you want a stored procedure to start multiple packages so they all run at the same time, then the easiest way is to create a job for each package. Then, in your procedure you can start the jobs - which will then run concurrently.

    I would recommend upgrading to SSIS and rebuilding the packages. With SSIS you can control that much more effectively in the package itself, instead of relying on SQL Server.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply