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 and select Delete, as shown in this screenshot:

3. Right-click on the project and select Properties from the contextual menu. As shown in the following screenshot, change the ProtectionLevel property of the project to Do not save sensitive data and click on OK in both windows. You'll get a warning telling you that you'll have to do the same for all packages in the project. We don't have any, so we simply get rid of the warning dialog. Sensitive...