SQL Task
 Previous Top Next
The SQL Task component allows you to execute a SQL statement or Stored Procedure on a database.  Any database compliant SQL statement can be executed. Data returned from the SQL statement will be available in other actions through the dataset name that you enter.

graphic
  
Populate Dataset
Enter the name of the internal dataset in Optitask that will be populated with the results of the SQL query.
Use Connection
Specifies the database connection to use with the SQL task. You can click on the ellipsis (…) button to open the Database Connection Manager.
SQL Statement
Enter the SQL Statement that you want to execute. To run a stored procedure add the word “exec” in front of the stored procedure name, for example: “exec somesp”
Multiple SQL queries can be separated by a semicolon (;).