View Integration Services Packages in SQL Server Management Studio (SSIS Service)

Important note Important

This topic discusses the Integration Services service, a Windows service for managing Integration Services packages. SQL Server 2012 supports the service for backward compatibility with earlier releases of Integration Services. Starting in SQL Server 2012, you can manage objects such as packages on the Integration Services server.

This procedure describes how to connect to Integration Services in SQL Server Management Studio and view a list of the packages that the Integration Services service manages.

To connect to Integration Services

  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Integration Services in the Server type list, provide a server name in the Server name box, and then click Connect.

    Important note Important

    If you cannot connect to Integration Services, the Integration Services service is likely not running. To learn the status of the service, click Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. In the left pane, click SQL Server Services. In the right pane, find the Integration Services service. Start the service if it is not already running.

    SQL Server Management Studio opens. By default the Object Explorer window is open and positioned in the lower-left corner of the studio. If Object Explorer is not open, click Object Explorer on the View menu.

To view the packages that Integration Services service manages

  1. In Object Explorer, expand the Stored Packages folder.

  2. Expand the Stored Packages subfolders to show packages.

Community Additions