Update and Insert option : Data transfer very slow

[Nandakishore]

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 .

[ed_hayter]

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

[Nandakishore]

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.