OData error Cannot acquire a managed connection from the run-time connection manager

Question

I'm suddenly facing the following error since 3 days while extracting SharePoint list by SSIS package, however my jobs were running without any issue since 2 years

Error: Cannot acquire a managed connection from the run-time connection manager.
[SSIS.Pipeline] Error: Contract Management failed validation and returned error code 0xC020801F.
Progress: Validating - 25 percent complete

Answer 1

Hi @Hamada Abdulmonsif ,

Someone who had met the same error said that they got this error since proxy was enabled in the server.

SSIS Package is not able to access Sharepoint List during execution when the proxy is enabled.

This is working fine after changing the connection to "automatically detect settings" in the internet options.

You may have a try.

Here are some other detailed resolution in this link, you may carefully refer to see if it will be useful.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October