How to open a DTS package saved to SQL Server (Enterprise Manager)
To open a DTS package saved to SQL Server
- In the SQL Server Enterprise Manager console tree, expand Data Transformation Services, and then click Local Packages.
- Do one of the following:
- Double-click the Data Transformation Services (DTS) package you want to open in DTS Designer.
- Right-click the DTS package you want to open, and then click Versions. In the DTS Package Versions dialog box, click the package version you want, and then click Edit.
- Double-click the Data Transformation Services (DTS) package you want to open in DTS Designer.