topic Re: Azure SQL - insert is too slow and Bulk error in Talend Studio

Azure SQL - insert is too slow and Bulk error

peterko — Fri, 03 Jul 2015 15:38:39 GMT

Hi everyone,
I have a problem with SQL Azure. Insert is a very slow. Do you have any suggestions for improvements?
When I use the BULK INSERT then I get the error:

I/O Error: DB server closed connection.

Re: Azure SQL - insert is too slow and Bulk error

Anonymous — Mon, 06 Jul 2015 04:20:20 GMT

Hi pantolik ,

Could you please show us your current job design? Have you checked out "Use Batch Size" option to activate the batch mode for data processing?
Best regards
Sabrina