title: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
body: <p>It has been a real struggle trying to get this to work on my Windows 7 64-bit machine.</p>
  
  <p>I have a package which moves data from Oracle to SQL and, on our Windows 2008 R2 test server it works fine (within BIDS).</p>
  
  <p>What I have tried so far....</p>
  
  <ul>
  <li><p>Copied BIDS from Program Files (x86)  to Program Files (to eliminate
  the brackets issue)</p></li>
  <li><p>Installed 32-bit and 64-bit Oracle as well as 32-bit ODAC.</p></li>
  <li><p>Tried setting DelayedValidation to TRUE</p></li>
  <li><p>Installed TOAD and am able to connect to Oracle database.</p></li>
  </ul>
  
  <p>Within BIDS, I can test the connection successfully and even preview it, however when I try to execute the package fails on the DataSource task (ie Oracle connection).</p>
  
  <p>Very frustrating and I appreciate any help on this. </p>
  
  <p>Complete error below:</p>
  
  <blockquote>
    <p>[OLE DB Source [1]] Error: SSIS Error Code
    DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The
    AcquireConnection method call to the connection manager "LICS" failed
    with error code 0xC0202009.  There may be error messages posted before
    this with more information on why the AcquireConnection method call
    failed.</p>
    
    <p>[SSIS.Pipeline] Error: component "OLE DB Source" (1) failed validation
    and returned error code 0xC020801C.</p>
  </blockquote>
  
  <p>thanks,</p>
  
  <p>KS</p>