SSIS Run multiple Execute Process tasks in parallel

Question

I have a package that needs to run the separate Execute process task that make command line calls in parallel.

I have tested this and SSIS seems to only allow them to execute consecutively (One call waits for the before it finishes despite being in separate simultaneous flows) Has anyone had any luck getting SSIS to run this in parallel

I provided an answer to solved it. But still waiting for a reply!!! — Hadi, Apr 27 '17 at 13:10

Hadi · Accepted Answer · 2017-03-31T03:52:42.477

3

Try adding a Sequence Container and inside it add multiple Execute process Task (separate tasks) and do not connect any task inside the container. Just connect the container with other items.

And check your Package MaxConcurrentExecutables property

edited Mar 31 '17 at 03:52

answered Mar 31 '17 at 03:21

Hadi

36,233
13
65
124

SSIS Run multiple Execute Process tasks in parallel

1 Answers1