SQL Server 2017 Integration Services Cookbook

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 ...