How to use Roll BAck and Commit transactions of SQL using uipath

Scenario: I have data 50 rows in excel. Need to insert all the row in SQL table. The Bot should insert either all 50 rows or none. If there is an exception with any single row of data then bot should not insert any data.

Please suggest how to use Rollback and commit transactions of SQL.

Hello…
Suggestion:
Better you can use the data validator before insertion only, because it takes more effort to rollback all the transactions processed.

DAta Validator: Do you mean validate data before trying for insert??? If that is what your suggestion… we are already doing this. We would like to know if we have direct approach of using Rollback and Commit

Okay my bad, will update if I find something.

If you get resolved keep posted :blush:

Use start transaction activity, it will take care of commit and rollback.
check details here [https://docs.uipath.com/activities/docs/database-transaction](http://Start Transaction)