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. We'll first create the SSIS Catalog in SSMS. Open SSMS and connect to your local instance:
  1. Look for the Integration Services Catalogs folder in object explorer.
  2. Right-click on it and select the option Create Catalog....
  1. If the Create Catalog... option is not available (disabled - greyed out), it means that a catalog has already been created. Even if the folder is called Integration Services Catalogs - plural, only one Integration Services Catalog can be created by the SQL Server instance. The Create Catalog dialog box appears: ...

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