This action creates a SQL Server transaction using the defined SQL Server Connection. The transaction can then be used by one or more Run SQL Server Query actions within the action list. The transaction object can also be accessed by custom or dynamic code actions through the Update Context object’s Shared Properties collection.
Prepare Stage
No action taken.
Execute Stage
Creates a SQL Server transaction and adds the transaction to the Update Context Shared Properties collection.
Cleanup Stage
No action taken.
Rollback Stage
If the transaction has not been committed, the transaction is rolled back.
Action Description - Descriptive text that can be used to identify this particular action in the Actions list.
Store the transaction – Defines the Shared Property key value that will hold this transaction.
Isolation level – Choose the SQL Transaction isolation level that this transaction will use.