SSIS Package failing with "Failed to acquire connection" error
I finally resolved the problem and it was related to my MSDTC settings. While MSDTC had been enabled, I had to enable the following settings:
- Network DTC Access
- Allow Remote Client
- Allow Inbound/Outbound
- Enable TIP
When using a "foreach loop" Container in a SSIS package, we had this error after processing 3K+ files... By setting the connection property RetainSameConnection to TRUE, we were able to move more than 32K files with no further issues.