I have come across an interesting scenario recently while working on one of the customer issues. The SSIS package fails during the execution, even though the Test Connection and Preview Data in the OData Source Task succeeds while connecting to the Dynamics AX OData Source.
Here is the error message we got:
[OData Source ] Error: Cannot acquire a managed connection from the run-time connection manager.
[SSIS.Pipeline] Error: OData Source failed validation and returned error code 0xC020801F
Let me give you a quick background of the issue. The SSIS 2014 Package fails during the execution while connecting to Dynamics AX Online OData Source with the below error:
The Fiddler trace looks like below
You can clearly see that HTTPS Handshake failed while trying to access the OData Source URL.