semaphore timeout in copy activity from Azure SQL DB to Blob Storage

Question

Hello,

We are trying to copy a large table from an Azure SQL database to blob storage but we keep getting the below error. The table has about 9.4 million records in it.

Any ideas what is causing it?

Thanks!

Error:

Type=System.Data.SqlClient.SqlException,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),Source=.Net SqlClient Data Provider,SqlErrorNumber=121,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=121,State=0,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),},],''Type=System.ComponentModel.Win32Exception,Message=The semaphore timeout period has expired,Source=