Integration services catalog setup

This step is necessary for brand new, unused SQL Server installations, where we want to deploy SSIS packages. When logged in to the server with SSMS, we simply right-click on the Integration Services Catalogs folder and choose Create Catalog...

The Create Catalog window appears. We fill in the properties and click on OK to create the integration services catalog:

Next, we'll create a folder for our project. In the Object Explorer, expand the Integration Services Catalogs node, right-click on SSISDB, and choose Create Folder... from the contextual menu that appears:

The Create Folder window appears. Set the ...

Get Hands-On Data Warehousing with Azure Data Factory now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.