Select Package

DTS Designer

DTS Designer Help

Select Package

Use this dialog box to select from Data Transformation Services (DTS) package versions saved to a structured storage file or to Microsoft® SQL Server™.

Selecting a Package Version Saved to a Structured Storage File

When you open a package saved to a structured storage file, if more than one package or package version is contained in the file, the Select Package dialog box appears. The dialog box contains a tree view of a package version history.

  • At the top node, a text file icon and accompanying label indicates the storage location for the package.

  • Package nodes are shown beneath the top node. Each of these nodes represents a different package. There can be multiple package nodes listed under a file, if different packages were saved under the same file name.

  • Version nodes with dates, indicating the complete version history of a package, are displayed beneath a package node.

Double-clicking a package icon loads the latest version of that package version; double-clicking a version icon loads that specific package version.

Selecting a Package Version Saved to SQL Server

The Select Package dialog box appears when you attempt to load a package saved to SQL Server with multiple versions. As with structured storage files with multiple versions, a tree view of the package history is displayed for selection. However, only versions for a single package are displayed; you do not save multiple packages to a single file, as is the case with a structured storage file.

Expand a package icon to view its version history, and then double-click on the package icon to load the latest version of the package, or click on a specific version to load that version.

See Also

Saving a DTS Package to a Structured Storage File

Saving a DTS Package to SQL Server

DTS Package Execution Utilities