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.