Executes a SQL batch against a SQL database.
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. |