Integration Services (SSIS) Server

After you design and test packages in SQL Server Data Tools, you can deploy the projects that contain the packages to the Integration Services server.

The Integration Services server is an instance of the SQL Server Database Engine that hosts the SSISDB database. The database stores the following objects: packages, projects, parameters, permissions, server properties, and operational history.

The SSISDB database exposes the object information in public views that you can query. The database also provides stored procedures that you can call to manage the objects.

Before you can deploy the projects to the Integration Services server, you need to create the SSISDB catalog.

For an overview of the SSISDB catalog functionality, see SSIS Catalog.

High Availability

Like other user databases, the SSISDB database does support database mirroring and replication. For more information about mirroring and replication, see Database Mirroring (SQL Server).

You can also provide high-availability of SSISDB and its contents by making use of SSIS and AlwaysOn Availability Groups. For more information, see this blog post by Matt Masson, SSIS with AlwaysOn, at blogs.msdn.com.

Integration Services Server in SQL Server Management Studio

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:

• SSISDB Database

  The SSISDB database appears under the Databases node in Object Explore. You can query the views and call the stored procedures that manage the Integration Services server and the objects that are stored on the server.

• Integration Services Catalogs

  Under the Integration Services Catalogs node there are folders for Integration Services projects and environments.

Related Tasks

• Create the SSIS Catalog

• View the List of Packages on the Integration Services Server

• Deploy Projects to Integration Services Server

• Run a Package on the SSIS Server Using SQL Server Management Studio

Related Content

Blog entry, SSIS with AlwaysOn, at blogs.msdn.com.

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN: Visit the Integration Services page on MSDN For automatic notification of these updates, subscribe to the rss feeds available on the page.