question

JawaherKhemakhem-3381 avatar image
0 Votes"
JawaherKhemakhem-3381 asked Monalv-msft commented

Parallel ssis execution



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?

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi @JawaherKhemakhem-3381 ,

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:
87210-t-sql.png
87251-parentpackage.png
87252-est-general.png
87166-est-resultset.png
87167-fl-collection.png
87129-fl-variablemappings.png
87168-ept-package.png
87104-ept-expressions.png

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.




t-sql.png (17.9 KiB)
parentpackage.png (63.7 KiB)
est-general.png (23.0 KiB)
est-resultset.png (10.3 KiB)
fl-collection.png (16.7 KiB)
ept-package.png (19.7 KiB)
ept-expressions.png (10.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Monalv-msft thank you for your answer. This is will execute packages sequentially and not in parallel.

0 Votes 0 ·
Monalv-msft avatar image Monalv-msft JawaherKhemakhem-3381 ·
0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.