Parallel ssis execution

Question

I have about 112 packages. Actually these packages are executing sequentially using package master.

I need to execute these packages parallel. I create package master and add all these packages manually but it's not easy for support and maintenance. Is there a way or an idea how to extract all packages names from table parameter for example, then execute them in parallel automatically and not add packages manually?

Answer 1

Hi @Jawaher Khemakhem ,

1.Please store the package name in sql table firstly.
2.Use the following sql query in Execute SQL Task:
SELECT PackageName FROM Package;

3.Then drag Foreach Loop Container and drag Execute Package Task in the container.

Please refer to the following pictures:

Best regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Actually these packages are executing sequentially using package master.

Make a copy of that package, edit it and remove all flow arrows/connecting lines, then all child packages will be executed in parallel.