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. In SQL Server Data Tools (Visual Studio), right-click on the DB.AdventureWorksLT project and select Publish..., as shown in the following screenshot:
  1. The following screen appears; click on the Edit... button to create a connection string to our local SQL Server instance:
  1. As shown in the following screenshot, clicking on the Browse tab brings up a screen where we can choose the SQL Server instance location. In our case, we'll choose Local. Expand the Local label and choose your SQL Server instance, in our case SSISCOOKBOOK ...

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