MicrosoftMicrosoftThis helped me a lot, I had changed some steps in a SSIS Job to run packages with the Default Setting RetainSameConnection = TRUE.
RetainSameConnection is a property of an OLEDB Connection Manager. The default value of this property is FALSE. This default value makes SSIS execution engine open a new OLEDB connection for each task that uses the connection and closes that connection when the task is complete.
The setting of this property to "TRUE" caused the SSIS Server to run out of ports to open a Connection to the Azure Database - which showed up as various SQL Errors at sporadic times during execution.
This article was a great help and resolved the issue. All open ports were closed once I had restarted the SSIS Server. Thank you!
