I setup a nightly job to load data from a database on premise to Azure.
The SSIS runs successfully intermittently, but sometime it fails.
The error is all about :
[Destination 2 ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ourcloudserver.database.windows.net.SSDEquipment" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
login timeout expired, unable to complete login process due to delay in login response.
So I guess this is an issue with connection issue time out , how can I fix this?
This package only runs totally 2 and half minutes.
How come it lost the connection in the middle. Our network has no problem.
I can login to the azure portal all the time.
And I run all this on the same machine that allow access to the azure portal