Extended SSIS Package Execute. The execute package task in SSIS , is lacking the ability to pass variables into the package to be executed. Not only that but the mechanism of using a For Each loop can be quite cumbersome.

This component attempts to resolve those short comings. It is designed to call a specified .dtsx package for each row in the data input. In addition, it supports multi-threading , set the maxdop to the required number of threads.

To Install
Run the installer.
Start a new bids session.
In the toolbox pane , Right click -> Choose items, on the SSIS data flow tab , you should now see "SSIS Package execute" as below. Select the tick box, and the control will now be in the toolbox.

Requirements:
* NET Framework
* Microsoft SQL Server

The license of this software is Free, you can free download and free use this server utility software.