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.