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.

The objects that are stored in the SSISDB catalog include projects, packages, parameters, environments, and operational history.

You inspect objects, settings, and operational data that are stored in the SSISDB catalog, by querying the views in the SSISDB database. You manage the objects by calling stored procedures in the SSISDB database or by using the UI of the SSISDB catalog. In many cases, the same task can be performed in the UI or by calling a stored procedure.

To maintain the SSISDB database, it is recommended that you apply standard enterprise policies for managing user databases.

You access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer. You access the SSISDB database in SQL Server Management Studio by expanding the Databases node in Object Explorer.

Points To Remember:

- You cannot rename the SSISDB database.

- If the SQL Server instance that the SSISDB database is attached to, stops or does not respond, the ISServerExec.exe process ends. A message is written to a Windows Event log.

- If the SQL Server resources fail over as part of a cluster failover, the running packages do not restart. You can use checkpoints to restart packages.

 Features and capabilities

• Catalog Object Identifiers
• Catalog Configuration
• Permissions
• Folders
• Projects and Packages
• Parameters
• Server Environments, Server Variables, and Server Environment References
• Executions and Validations

For More Information, kindly click on below link:

https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog