The AcquireConnection method call to the connection manager failed with error code 0xC0202009

Error message:

[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "REMEDY" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.[SSIS.Pipeline] Error: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

• I'm trying to import data from ORACLE DB to SQL SERVER DB but receive the above error at package "execution" phase
• OLEDB connection manager to ORACLE is successful when tested.
• In DFT No error or warning after columns mapped
• IN OLEDB source, no error or warning. Able to parse the SQL query and preview the columns to build queries.
• Oracle client 32bit. ORACLE HOME path is set to D:\app\product\instantclient_11_2
• Have installed 64 bit, instant client, also and configured the ORACLE_HOME also.

I tried the below troubleshooting,

1. changed the transactionOption to NotSupported ( For control flow and DFT properties both)
2. Have set the delayValidation to TRUE ( DFT properties )
3. Have set the => Project -> Properties -> Debugging -> Run64BitRunTime = False
4. Tried executing the package via DTEXEC utility
5. Package protection level is EncryptSensitiveWithPassword
6. Have set the 32bit runtime execution at SSIS JOB

But still, receive the same error. Requesting assistance.

I have upgraded to SSDT 2012 and utilized Oracle Attunity driver to resolve this issue. Thanks digital.aaron & billinkc for your intreset on my question