SQL Server Performance Forum – Threads Archive

Import DTS File

How can I import a DTS file to a new SQL Server?

BOL defines :
How to open a DTS package saved to a structured storage file (Enterprise Manager)
To open a DTS package saved to a structured storage file In the SQL Server Enterprise Manager console tree, right-click Data Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click Open.
If multiple Data Transformation Services (DTS) packages or package versions were saved, the Select Package dialog box appears. Click the package or package version you want to open.
How to open a DTS package saved to Meta Data Services (Enterprise Manager)
To open a DTS package saved to Meta Data Services In the SQL Server Enterprise Manager console tree, expand Data Transformation Services, and then double-click Meta Data Services 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. 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 HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>