• Article

Execute DTS 2000 Package Task Editor (General Page)

Use the General page of the Execute DTS 2000 Package Task Editor dialog box to specify the SQL Server 2000 package that the task runs.

To learn about this task, see Execute DTS 2000 Package Task.

Important

The Execute DTS 2000 Package task is provided only for purposes of backward compatibility with the deprecated component, Data Transformation Services (DTS). For more information, see Data Transformation Services (DTS).

Important

SQL Server 2008 does not install run-time support for DTS packages. You have to install this run-time support before you can run DTS packages. For information about how to install support for DTS, see How to: Install Support for Data Transformation Services Packages.

Static Options

  • Name
    Provide a unique name for the Execute DTS 2000 Package task. This name is used as the label in the task icon.

    Note

    Task names must be unique within a package.

  • Description
    Type a description of the Execute DTS 2000 Package task.

  • StorageLocation
    Select the storage location type of the child package. This property has the options listed in the following table.

    Value

    Description

    SQL Server

    The storage location is an instance of SQL Server. Selecting this option displays the dynamic options, SQLServer, AuthenticationMode, UserName, and Password.

    Structured Storage File

    The storage location is a structured storage file. Selecting this option displays the dynamic option, File.

    Embedded in Task

    The storage location is within the Execute DTS 2000 Package task.

  • PackageName
    Type the name of the SQL Server 2000 package, or click the ellipsis (…) and locate the package.

  • PackagePassword
    If the SQL Server 2000 DTS package is password protected, provide the password.

  • PackageID
    Optionally, update the unique identifier of the package version.

  • Edit Package
    Click to open the DTS 2000 package designer in which you can view or modify the DTS package.

    Neither SQL Server 2008, nor SQL Server 2005, installs the DTS package designer. If the DTS 2000 package designer is not installed and you click Edit Package, a warning message prompts you to install the designer. For information about how to install design-time support for DTS packages, see How to: Install Support for Data Transformation Services Packages.

    Note

    The DTS package designer works with the SQL Server 2008 tools, but the designer's features have not been updated for SQL Server 2008.

  • Load DTS2000 Package Internally
    Click to store the DTS package inside the Integration Services parent package.