Advanced DTS Run
New Information - SQL Server 2000 SP3.
Use this dialog box to view or edit various options for Data Transformation Services (DTS) global variables, logging, and encryption settings.
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.
Create a new global variable for the duration of a DTS Run utility session.
Delete a global variable for the duration of a DTS Run utility session.
Type the name of the text file containing DTS package execution error information.
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.
Display the command line equivalent to the options selected in the DTS Run utility.
Security Note Encrypt the command statement when you plan to copy the statement and save it in a text file.
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.