SQL Batch

Executes a SQL batch against a SQL database.

To create this step select SQL Batch from the list and then enter in a name for the step.

You can either use a connection stored in the Ouvvi Connection library by selecting the connection from the dropdown, or you can configure the connection manually.

Enter in a SQL Batch statement to be executed and enter the statement separator that should be used.

Parameter	Description
Connection Library	The name of the connection in the connection library. If this is selected then you do not need to complete the other fields.
Connection Provider	Type of Connection String (Optional: provided by Connection Library).
Connection String	Database Connection String (Optional: provided by Connection Library).
Connection Timeout	The time it will take for the connection to timeout.
SQL Batch Filename	The name of the SQL batch file.
SQL Batch	The SQL batch to be run.
Statement Separator	The separator for the SQl statement i.e. GO.
Run Batch in Transaction	Check the checkbox to run the batch in transaction.
Log each statement in the batch	Check the checkbox to log each statement in the bath.