Executing a package using scale out functionality

Finally, we're able to do the real work: creating a simple package and execute it in scale out mode.

Getting ready

You will need SQL Server 2017, SSIS 2017, SSDT, and SSMS 2017 to complete this recipe. It is also assumed that you have configured SSIS in the previous recipe.

How to do it...

1. Open SSDT and create a new SSIS project named SSISCookBookScaleOut, as shown in the following screenshot. Click on OK to create it:

2. In the Solution Explorer, right-click on the Package.dtsx that is created with the project...