SQL Server Performance

Import DTS File

Discussion in 'SQL Server DTS-Related Questions' started by vpathisseril, Jul 7, 2005.

  1. vpathisseril New Member

    How can I import a DTS file to a new SQL Server?
  2. satya Moderator

    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.

Share This Page