Export (0) Print
Expand All

DTS Run

SQL Server 2000

Use this dialog box to select a Data Transformation Services (DTS) package to run and to specify its connection settings and scheduling options.

Options

Location

Select whether the DTS package is stored in Microsoft® SQL Server™, SQL Server 2000 Meta Data Services, or a structured storage file.

Package Name

Select an existing package stored in SQL Server, Meta Data Services, or as a structured storage file to be run. If a single package of the type you specified in Location exists, that package is specified. If multiple packages exist, no package is specified, and you must click the browse (...) button to select a package.

Advanced

Display the Advanced DTS Run dialog box, where you generate global variable, logging, encryption, and command prompt selections .

Date

View the current date and time.

Version

View the globally unique identifier (GUID) for the version of the selected package.

Server

Specify the name of the server on which the package is stored. This option is available for packages saved to SQL Server and Meta Data Services only.

Use Windows Authentication

Specify Windows Authentication for login. This option is available only if you save the package to SQL Server.

Use SQL Server Authentication

Specify SQL Server Authentication for login. This option is available only if you save the package to SQL Server.

User name

Specify a user name for the connection.

Password

Specify a password for the connection.

Run

Execute the selected package.

Schedule

Display the Edit Recurring Job Schedule dialog box, where you can schedule package execution on a regular basis.

See Also

dtsrun Utility

Executing a DTS Package

Scheduling a DTS Package for Execution

Show:
© 2014 Microsoft