Connection timed out (Read failed)

Copper Contributor

Hello All,


I have created an ETL job which will load data from SQL server 2012 to Azure SQL Server. All the data from source will be fetched and inserted into destination. I am running multiple jobs in parallel.

I am facing the below error. When anyone of the job fails due to this, all the other jobs running in parallel also fails due to read time out. Connection timed out (Read failed)


1. How to increase the timeout?. Is there a way to increase timeout for each query?

2. How to prevent other jobs/queries failing when one job/query fails?



0 Replies