I have a datatable DT with 25 columns .I want to insert the data from DT to sql table SQDT with same columns .I’m using Insert Query for now Is there a better way to approach this problem instead of using Insert on each record can i bulk insert into database using stored procedure or some other efficient way.It takes a lot of time to insert as DT has about 130000 tuples
Insert Datatable to Database Table using UIPATH activity( using stored procedure or some other efficient way)
Yes, you can use Bulk insert query in Execute query Activity based on your database.
SQL Server supports Bulk insert Query. You can use store Procedure as well.