Update and Insert option : Data transfer very slow

Question

Hello All,

I have this issue while loading the records into DB as update and insert which takes more than 1hr to load 80K records .

Is there anyway to bring down the time as records load will increase in future .

Also , changed the DB connection from ODBC to OLEDB too , but same result.

Please suggest .

Nandakishore · Answer

Hi @ed_hayter ,

I tried to use . But there is no update and insert option for Bulk SQL Server .

Am i missing anything here.

Thanks for help.

ed_hayter · Answer

If you have a bulk connector option available to you this can improve write speeds to a database.