Unable to insert larger amount of data in database

Automation Studio Excel Automation
1

Hi,
I have 2 lakh records in the excel file and I have to insert that into database.
I’m using excel loop activity inside that “Execute DB query” to insert data into database. But because of many records all the records are not getting inserted and error is coming execution timeout.

I increased the seconds but still its not working, can some one please help me how to proceed with that.
Is there any way, if I divide the data into 4-5 excel and run all excels parallelly or is there any other solution?

Thanks in advance!

2

Hi,

Try increasing the time out at Studio Level also. Else the process run will time out in 50 sec. Parallel approach is also fine.

Regards,
Amit