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.