I created a data table in UiPath that I then want to be mass uploaded to a SQL Database. I setup an Execute Query, Insert & Disconnect from the Database Activity, but this uploads my data to the SQL Database one line at a time. This takes 10 minutes to get all 50,000 lines to flow.
Suggestions on a way to have the data be mass uploaded all at once instead of 1 line at a time?
Thanks for quick reply. I utilized the INSERT activity and it works. This activity uploads my data 1 line at a time into the SQL database. Is there a way to have the data mass uploaded (all lines in data table uploaded at one time) instead?