Steps

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.