DTS Run
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.