Oracle 10g client - SSIS Package OLEDB native can't resolve TNS ORA-12154
Posted on 2011-02-16
We are migrating a SSIS package from a 32 bit server to 64 bit. When we run a batch file that calls the DTSX we get the error now:
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "IU Data" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for ODBC Drivers" Hresult: 0x80004005 Description: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
When I go into the SSIS package and try to test connection on the OLEDB Oracle Provider it throws a error:
ORA-12154 - TNS: could not resolve the connect identifer
I can TNSPING no problem to the instance name etc. Any idea what I need to install to fix this?