Execute SQL Task Properties

DTS Designer

DTS Designer Help

Execute SQL Task Properties

Use this dialog box to name the task, specify the data connection, specify the SQL statements to execute, and set the connection time-out.

Options

Description

Type a description of the Execute SQL task. This description becomes the label on the Data Transformation Services (DTS) Designer design sheet.

Existing connection

Choose the connection to the appropriate data against which you want the SQL statement to run.

Command Timeout

Specify the value that determines the maximum number of seconds the execution can take before timing out. A value of zero indicates an infinite amount of time.

SQL Statement

Specify the SQL statement to execute. You can separate multiple queries with the GO statement.

Parameters

Display the Parameter Mapping dialog box, where you can map global variables as either input parameters to your SQL statement or as output parameters to contain the results of a query. If you create an SQL statement with a parameter marker and the Parameters button is not enabled, the selected provider does not support parameterized queries.

Parse Query

Check the syntax of the SQL statements. The OLE DB provider provides syntax checking for standard SQL syntax. The syntax checking will not catch errors in complicated expressions, nor does it support the use of non-standard SQL constructs, such as parameter markers and comments. Error messages related to incorrect syntax should be verified and can be ignored if you find that the SQL statement is valid.

Build Query

Create the SQL statement to execute using DTS Query Designer, a graphical query-building tool.

Browse

Display the Selected File dialog box, where you can select a file containing prewritten SQL statements. When a file is selected, the SQL contained in that file is copied into the SQL statement text area.

See Also

Execute SQL Task

ExecuteSQLTask Object