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

How to: View Data Transformation Se...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

SQL Server 2008 Books Online (June 2009)

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

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 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.

Important:
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.

Important:

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

In Object Explorer, expand the Management folder.
Expand the Legacy subfolder.
Expand the Data Transformation Services subfolder to show packages.

Tasks

Concepts

Other Resources

Help and Information