How To Create SSIS Catalog

Introduction 
 
Let’s say you are done designing and testing your SQL Server package and you want to deploy the package to an Integration Services server. Before you deploy the package, you need to create SSIS Catalog in Integration Service Catalogs.
 

SSIS Catalog?

 
The SSISDB catalog is the central point for working with Integration Services (SSIS) projects that you've deployed to the Integration Services server. For example, you set project and package parameters, configure environments to specify runtime values for packages, execute and troubleshoot packages, and manage Integration Services server operations.
 
Let’s get started:
 
Connect to SQL Server Management Studio
 
How To Create SSIS Catalog
 
Go to Integration Services Catalogs
 
How To Create SSIS Catalog
 
Right-click and hit Create Catalog
 
How To Create SSIS Catalog
 
Provide Catalog name and check Enable automatic executions and provide a password.
 
How To Create SSIS Catalog
 
Click OK, and as you can see SSIS Catalog is created
 
How To Create SSIS Catalog
 
You can right-click on SSIS Catalog and create a folder there and deploy the packages.
 
How To Create SSIS Catalog
 

Conclusion


In this article, we have learned how to create SSIS Catalog in the Integration Services Catalog in SQL Server Management Studio.