Quick answer: To create an SSIS Catalog in SQL Server, connect to the Database Engine in SSMS, expand Integration Services Catalogs, right-click the node, and select Create Catalog. Enable CLR integration, enter a password for the catalog database master key, and create the catalog.
The SSIS Catalog creates the SSISDB database used by the project deployment model to store SSIS projects, environments, executions, and related metadata.
Prerequisite:
You need sufficient permissions on the SQL Server instance to create the SSISDB catalog.
Create SSIS Catalog in SQL Server
1. Open SQL Server Management Studio and connect to the SQL Server Database Engine.
2. In Object Explorer, expand the server node, right-click Integration Services Catalogs, and select Create Catalog.
Available on Microsoft Store
SSRS Reports Migration Wizard
A simple Windows tool for migrating SSRS reports, data sources, and related configurations between report servers.
3. In the Catalog Creation Wizard, select Enable CLR Integration.
4. Optionally enable automatic execution of the SSIS startup procedure when the SQL Server instance starts. This helps maintain the state of SSIS operations after an instance restart.
5. Enter a password to protect the database master key used to encrypt catalog data. Store the password securely and keep a backup of the database master key.
Select OK. SQL Server creates the SSISDB database under Integration Services Catalogs. You can then deploy SSIS projects using the project deployment model.
Pro tips:
1. Keep the SSISDB encryption password secure because it protects the catalog database master key.
2. If you are migrating an existing SSISDB between SQL Server instances, consider using SSIS Catalog Migration Wizard to migrate SSIS catalog projects and configurations.
See more
Visual Studio Marketplace
SSIS Catalog Migration Wizard
Extend Visual Studio with an easy way to migrate SSIS Catalog projects.
