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. From SSDT, right-click on the ETL.Staging project and choose Deploy from the contextual menu, as shown in the following screenshot:
  1. From the Integration Services Deployment Wizard, create SSISCookBookSolution, as shown in the following screenshot:
  1. Click on OK twice to dismiss both the Create New Folder and the Browse for Folder in Project windows. Make sure that the path is named /SSISDB/SSISCookBookSolution/ETL.Staging and click on Next and then Deploy to deploy the project.
  2. Once deployed, go back to SSMS; we're going ...

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