Share via


How to: View Integration Services Packages in SQL Server Management Studio

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

    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.