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…

[image] OviattTG: 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? Fine then we can use EXECUTE QUERY activity itself with a SQL Statement having Insert with Bulk insert …

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? @Palaniyappan

I’d recommend using the Execute NonQuery activity instead of the insert, then just write your own INSERT statement. I had a lot of trouble trying to use the built-in insert activity

Mass Upload Data Table to SQL Database

Help

Palaniyappan (Palaniyappan P ) July 31, 2019, 2:04pm 2

Hi
welcome to UiPath community
we got an activity to pass datatable as input with INSERT activity under the same UiPath.Database.Activities

hope that would help you

Cheers @OviattTG

Insert data from data from datatable to database

Topic		Replies	Views
Insert data from data from datatable to database Activities uiautomation , activities , question	6	4553	March 27, 2021
Bulk Upload to Database Using UiPath Help studio	4	4179	April 8, 2020
Insert Datatable to Database Table using UIPATH activity( using stored procedure or some other efficient way) IT Automation activities	2	1910	November 27, 2019
Insert data into sql database Studio database	9	3934	May 26, 2021
Insert data from csv to sql database Help excel , database	3	2710	January 22, 2020

Mass Upload Data Table to SQL Database

Related topics