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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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.
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.