Four Stars

Azure SQL - insert is too slow and Bulk error

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.
1 REPLY
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.