Why to use bulk insert activity that is coming with new database. activities?

can anyone give an automation example of usage of bulk insert in studio?when to use and when to replace insert activity?

Hello @ydash999

Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database.

One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data.

But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert to insert all the data to DB in a single call to database .

2 Likes

thankss bro!

1 Like

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