We have to insert excel data in sql but because of data is 3 lakh it is taking to much time to insert how we can upload data in chunks …
Did this help you buddy
@Gauri_Rawool Is it a .csv file or an .xls or .xlsx file?
can u share me the workflow
@Gauri_Rawool Have you tried using Insert Activity from Database Activities?
yes i am using insert activity…it is taking to much time
@Gauri_Rawool How long does it take ?
@Gauri_Rawool I don’t think Insert Activity takes more time, I guess reading the Excel File Using Read Range takes more time