Finally, we're able to do the real work: creating a simple package and execute it in scale out mode.
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.
- Open SSDT and create a new SSIS project named
SSISCookBookScaleOut, as shown in the following screenshot. Click onOKto create it:
- In the
Solution Explorer, right-click on thePackage.dtsxthat is created with the project and selectDelete, as shown in this screenshot:
- Right-click on the project and select
Propertiesfrom the contextual menu. As shown in the following screenshot, change theProtectionLevelproperty of the project toDo not save sensitive dataand click onOKin 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...
