Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

View the List of Packages on the Integration Services Server

SQL Server 2012

You can view the list of packages that are stored on the Integration Services server in one of three ways.

Transact-SQL access

To view the list of packages that are stored on the server, query the view, catalog.packages (SSISDB Database).

Programmatic access through the managed API

See the Microsoft.SqlServer.IntegrationServices.Store namespace and its classes, especially the Microsoft.SqlServer.IntegrationServices.Store.IntegrationStore class and its Microsoft.SqlServer.IntegrationServices.Store.IntegrationStore.Packages property.

In SQL Server Management Studio

To view packages stored on the server by using Object Explorer in SQL Server Management Studio, follow the procedure below.

To view packages using SQL Server Management Studio

  1. In SQL Server Management Studio, connect to the Integration Services server. That is, connect to the instance of the SQL Server Database Engine that hosts the Integration Services database.

  2. In Object Explorer, expand the tree to display the Integration Services Catalogs node.

  3. Expand the Integration Services Catalogs node to display the SSISDB node.

  4. Expand the SSISDB node to display a list of one or more folders. Each folder contains one or more projects in the Projects folder, and each project contains one more packages in the Packages folder.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.