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.

Go to Integration Services Catalogs.

Right-click and hit Create Catalog.

Provide Catalog name and check Enable automatic executions and provide a password.

Click OK, and as you can see SSIS Catalog is created.

You can right-click on SSIS Catalog create a folder there and deploy the packages.

Conclusion

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