View Integration Services Packages in SQL Server Management Studio (SSIS Service)
Applies To: SQL Server 2016
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.
Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.
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.
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.
In Object Explorer, expand the Stored Packages folder.
Expand the Stored Packages subfolders to show packages.