O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:
  1. In the Solution Explorer, right-click on the Package.dtsx that is created with the project and select Delete, as shown in this screenshot:
  1. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required