How to: View Data Transformation Services Packages in SQL Server Management Studio

This topic describes the following procedures:

  • How to connect to an instance of SQL Server Database Engine in SQL Server Management Studio.

  • How to view a list of the Data Transformation Services (DTS) packages that are stored in the msdb database on that instance of the Database Engine.

For more information about DTS support in Integration Services, see Support for Data Transformation Services (DTS) in SQL Server 2008.

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 the following options:

    • In the Server type list, select Database Engine.

    • In the Server name box, provide a server name, and instance name, if applicable.

    • Click Connect.


      If you cannot connect to SQL Server Database Engine, the SQL Server Database Engine 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 pane on the right side of the window, find the SQL Server 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, on the View menu, click Object Explorer.

To view the DTS packages that are stored on this instance

  1. In Object Explorer, expand the Management folder.

  2. Expand the Legacy subfolder.

  3. Expand the Data Transformation Services subfolder to show packages.