How to use transaction block while dealing with database

Help Something Else
1

I have data over 100 rows in excel. Need to insert all the row in Database one by one. The Bot should insert either all 100 rows or none. which means If there is an exception in any one row insertion of data then bot should not insert any data.

Please suggest how to use Rollback and use transaction blocks using UiPath studio.

2

Hi @Biswajeet_kumar

Please find the below thread.

Regards,
Chandrika.

3

@Biswajeet_kumar,

Use Activities - Start Transaction activity for this.

Thanks,
Ashok :slight_smile:

1 Like
4

this will help I guess, Thanks @ashokkarale

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.