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 SQL Server Management Studio and connect to the newly installed SQL Server 2017 instance.
  2. In the Object Explorer, right-click on the Integration Services Catalogs node and select Create Catalog.
  3. The Create Catalog window appears. As shown in the following screenshot, check the Enable this server as SSIS scale out master option as well as providing a password for the catalog. Click on OK when finished.
  1. Still in SSMS, run the following SQL statements. The first statement lists the workers available. Copy the WorkerAgentId into the clipboard by right-clicking on the value in the grid and select Copy. Type the second SQL ...

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