|
Execute SQL Statement
Passes an SQL statement to the datasource.
Click here to show the figure
Parameters
-
Connection string Specifies a string used to establish a connection to a data source.
The connection string provides driver, server, username, password and other important
information to the datasource. The easiest way to generate a connection string
is by pressing the right button.
-
SQL statement Specifies the SQL statement that should be executed.
-
Return number of records affected by SQL statement (Optional) Specifies the name of the variable, which receives the value of the number of records that the execution the SQL statement affected.
-
Dataset type Specifies the dataset type if the dataset should be created for the results of the SQL
Statement upon execution.
-
Dataset name (Optional) Specifies the name for the dataset. The name will be referred in subsequent
steps for accessing the data.
|