How to edit a DTS package saved to SQL Server or Meta Data Services (Enterprise Manager)

How to Install SQL Server 2000

How To

How to edit a DTS package saved to SQL Server or Meta Data Services (Enterprise Manager)

To edit a DTS package saved to SQL Server or Meta Data Services

  1. In the SQL Server Enterprise Manager console tree, expand Data Transformation Services.

  2. Do one of the following:
    • Click Local Packages for Data Transformation Services (DTS) packages saved to Microsoft® SQL Server™.

    • Click Meta Data Services Packages for packages saved to SQL Server 2000 Meta Data Services.
  3. In the details pane, double-click the DTS package you want to open in DTS Designer.

See Also

Managing a DTS Package

Saving a DTS Package to Meta Data Services

Saving a DTS Package to SQL Server