title: SSIS Package execution throw error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
body: <p>We try to test the simple Import from Excel File saved on a shared path on a server into a <code>SQL Table</code>. 
  I created the <code>Excel Connection Manager</code> for the <code>Excel</code> source file <code>97-2003</code>, <code>First row has column names</code> checked.
  I created the <code>OLEDB Destination</code> with the selected Table and I mapped the columns. </p>
  
  <p><a href="https://i.stack.imgur.com/mXe3I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mXe3I.png" alt="enter image description here"></a></p>
  
  <p>So fine so good, but when we run the Package the following error is thrown:</p>
  
  <pre><code>Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  
  The AcquireConnection method call to the connection manager "Excel Connection Manager" 
  failed with error code 0xC0202009.  
  There may be error messages posted before this with more information on why the AcquireConnection 
  method call failed.
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/2FwUy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2FwUy.png" alt="enter image description here"></a></p>
  
  <p>What do we tried:</p>
  
  <ul>
  <li>checked the access to the file</li>
  <li>to set <code>Delay Validation</code> to True on Package Level </li>
  <li>to recreate the <code>Excel Connection Manager</code></li>
  <li>to deploy the Package and execute inside the <code>Integration Services Catalogs</code></li>
  </ul>