I want to execute two or more procedures in parallel

Question

I have a list of procedures. All procedures are independent of each other. Therefore, I need to do to run independent procedures in parallel. I have 4 procedures that should be performed in parallel. When the procedures are successful, now I need to move on to the next task. These procedures create about 10 tables.

The next task is to complete a set of procedures. I made one table where I describe the dependency of these procedures with the tables created above. After completing any of the above procedures, I must come to this set of procedures and find out those procedures whose dependency tables have already been created. If any procedure whose creation of dependent tables is completed, I need to perform this procedure.

Performing 4 parallel procedures is performed by dts. But the difficulty for me is to transfer the task from the above 4 procedures to the next set of procedures. Please help me complete my task.

Thanks in advance

Answer 1

In a nut shell you cannot.

The DTS / SSIS task will wait for all 4 proc to complete: you cannot asynchronously continue one thread / connection in the DTS / SSIS task, which runs in parallel

I would think of using a wrapper stored in proc to run one of the 1st, a test for tables, and start other stored processes. Thus, the DTS / SSIS task can run 4 wrappers at a time.

4 SSIS, "" .

Answer 2

Sql? 2000 , DTS, 2005 , SSIS.