Export (0) Print
Expand All
Expand Minimize

Execute DTS 2000 Package Task Editor (General Page)

Updated: 15 September 2007

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.

Name

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

ms183497.note(en-US,SQL.90).gifNote:
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

Meta Data Services

The storage location is Meta Data Services. Selecting this option displays the dynamic options, SQLServer, AuthenticationMode, UserName, and Password.

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.

SQL Server 2005 does not install 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. To download and install an updated version of the DTS package designer, go to the Microsoft Web page, Feature Pack for Microsoft SQL Server 2005, and then download the Microsoft SQL Server 2000 DTS Designer Components.

Load DTS2000 Package Internally

Click to store the DTS package inside the Integration Services parent package.

Release History

15 September 2007

New content:
  • Added descriptions for the Edit Package and Load DTS200 Package Internally options.

Community Additions

ADD
Show:
© 2014 Microsoft