SQL Batch

Executes a SQL batch against a SQL database.

SQL Batch

Parameter	Value
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.