The SSISDB database appears under the Databases node in Object Explore. When you connect to an instance of the SQL Server Database Engine that hosts the SSISDB database, you see the following objects in Object Explorer: Integration Services Server in SQL Server Management Studio Also see this blog post by Matt Masson, SSIS with Always On, at. For more information, see Always On for SSIS Catalog (SSISDB. You can also provide high-availability of SSISDB and its contents by making use of SSIS and Always On Availability Groups. For more information about mirroring and replication, see Database Mirroring (SQL Server). Like other user databases, the SSISDB database supports database mirroring and replication.
The database also provides stored procedures that you can call to manage the objects.īefore you can deploy the projects to the Integration Services server, you need to create the SSISDB catalog.įor an overview of the SSISDB catalog functionality, see SSIS Catalog.
The SSISDB database exposes the object information in public views that you can query. The database stores the following objects: packages, projects, parameters, permissions, server properties, and operational history. The Integration Services server is an instance of the SQL Server Database Engine that hosts the SSISDB database.
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data FactoryĪfter you design and test packages in SQL Server Data Tools, you can deploy the projects that contain the packages to the Integration Services server.