title: How to fix "[OData Source [56]] Error: Cannot acquire a managed connection from the run-time connection manager." error in SSIS?
body: <p>I am having problem when running SSIS which extracts data from SharePoint list. SSIS Package was running fine till 2 weeks back and suddenly the package is failing with this error:</p>
  <blockquote>
  <p>[OData Source [56]] Error: Cannot acquire a managed connection from the run-time connection manager.
  [SSIS.Pipeline] Error: OData Source failed validation and returned error code 0xC020801F.
  [SSIS.Pipeline] Error: One or more component failed validation.
  Error: There were errors during task validation</p>
  </blockquote>
  <p>Tried:</p>
  <ol>
  <li>Changing 64bit debug option in package properties to false</li>
  <li><code>http://</code> instead of <code>https://</code></li>
  </ol>
  <p>I expect SSIS package to extract data from SharePoint list without any issues but facing the above error message recently which was working fine for more than a year.</p>
  <blockquote>
  <p>Server detail: Windows server 2012 R2.</p>
  <p>Application details: Visual studio 2010, .NET framework - 4.5</p>
  </blockquote>
  <hr />
  <h1>Update @ 2019-02-17</h1>
  <p>We are not using windows authentication and SSIS Passage is getting failed even after running SSDT as administrator. We are able to preview the Sharepoint list data in ODATA Source, but package is getting failed with the mentioned error message when triggered</p>