Post reply

making tasks run parrallel in DTS?

  • July 2, 2007 at 11:44 am

    #117690

    I have 4 tasks for importing tables into a database in DTS, but I want to know how I can make all those work parrallel. They just import tables, but right now its doing it one by one. How do I set the workflow so that all 4 happen at the same time.

  • July 2, 2007 at 11:57 am

    #716619

    this is how my workflow lookgs like right now

     

  • July 3, 2007 at 2:05 am

    #716782

    What you will need to do is to create one server connection per task - if you want to run 4 tasks in parallel you will need 4 separate connections to the server. 

    NB  When you create an SQL Server connection you can choose whether it is a NEW CONNECTION or an EXISTING CONNECTION.  You will have to choose NEW CONNECTION.

    J

  • July 3, 2007 at 8:37 am

    #716899

    The way you have it set up now, with two connections for source and destination, I would expect two imports to run in parallel.  As Jeremy said, if you have four connections for source and destination, all four would run in parallel.

    Greg

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

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