title: SSIS cannot acquire connection manager when executing a task but connects successfully in manager and shows preview data
body: <p>I get below error message when I try to execute the datflow task in SSIS. the connection manager connects successfully when I test the conn. I can also preview data from the OLE DB source. I get error when I try to execute though,</p>
  
  <p>[[1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the 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.</p>
  
  <p>[SSIS.Pipeline] Error: component "" (1) failed validation and returned error code 0xC020801C.</p>
  
  <p>I tried the below change and nothing worked:</p>
  
  <ul>
  <li>Set False to Run64BitRunTime</li>
  <li>Tried Delay Validation with both true and false</li>
  <li>Set Transaction Option not supported</li>
  </ul>
  
  <p>Are there any other options which I should modify ? SSIS 2008 version is being used.The data flow tasks connects to a Oralce DB. the connection manager uses Oracle Provider fro OLE DB</p>