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

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