CODEWITHSUNDEEP
sql-serverssisetlexecuteprocesstask
tbdevmanager
tbdevmanager

Reputation: 383

SSIS Run multiple Execute Process tasks in parallel

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

Upvotes: 3

Views: 3441

Answers (1)

Hadi
Hadi

Reputation: 37313

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

enter image description here

Upvotes: 4

Related Questions