Advanced DTS Run
Use this dialog box to view or edit various options for Data Transformation Services (DTS) global variables, logging, and encryption settings.
Options
Variables
Add a global variable or temporarily change the name, data type, and value of an existing package global variable. Any additions or changes exist only for the duration of a dtsrun execution. After the DTS Run utility is closed, changes to existing global variables are not saved, and global variables added during a DTS Run utility session are discarded.
New
Create a new global variable for the duration of a DTS Run utility session.
Delete
Delete a global variable for the duration of a DTS Run utility session.
Log File
Type the name of the text file containing DTS package execution error information.
Browse
Select a package execution log file.
Write completion status to event log
Include a completion status of package execution in the Microsoft® Windows® application log.
Encrypt the command
Encrypt the dtsrun command prompt statement according to SQL Server 2000 encryption. Click Generate to display the encrypted text in the command prompt box. The /Z command prompt switch is shown, followed by the encrypted text for the entire command prompt.
SQL Server 7.0 Format
Encrypt the dtsrun command prompt statement according to SQL Server 7.0 encryption. You need to select this option if you are scheduling packages on an instance of SQL Server 7.0. Click Generate to display the encrypted text in the command prompt box. Only the parameter values are encrypted; the dtsrun.exe command and the command prompt switches are not.
Command line
Display the command line equivalent to the options selected in the DTS Run utility.
Generate
Generate the text displayed in the Command Line box. If you select the Encrypt the command check box, the parameter values in the generated command are encrypted. Generating a command prompt is useful if you want to execute dtsrun from batch files or from SQL Server Agent.