can anyone give an automation example of usage of bulk insert in studio?when to use and when to replace insert activity?
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 .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.