Blog Post

Azure Database Support Blog
4 MIN READ

SSIS package fails with 'Communication link failure'

MelaniaNitu's avatar
MelaniaNitu
Icon for Microsoft rankMicrosoft
Oct 20, 2020
  “Communication Link Failure” is often due to outdated drivers or poor network configuration settings.   Please note OLEDB driver it is not maintained anymore and it is not recommended to use ...
Updated Oct 20, 2020
Version 2.0
Johannes_Vink's avatar
Johannes_Vink
Brass Contributor
Oct 29, 2020

We ran into infrequent connections errors from/to our PaaS databases with SSIS. There is not much information to be found on the internet, but after switching to the newest MSOLEDBSQL drivers, we've not seen the connection errors anymore.

 

The connection error due to scaling the Azure SQL DB was of course still there. Any idea how to work around that? The SSIS packages are still iaas, thus via the job agent we simply wait 1 minute, then start again. But with long running packages this is a time loss.