Export (0) Print
Expand All

Advanced DTS Run

SQL Server 2000

  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.

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.

Security Note  Encrypt the command statement when you plan to copy the statement and save it in a text file.

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.

See Also

dtsrun Utility

Executing a DTS Package

Scheduling a DTS Package for Execution

Show:
© 2014 Microsoft