[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1575
  • Last Modified:

Oracle 10g client - SSIS Package OLEDB native can't resolve TNS ORA-12154

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?
0
sbornstein2
Asked:
sbornstein2
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Did you upgrade the Oracle drivers to 64Bit?
0
 
sbornstein2Author Commented:
I found the 64 bit install did the install the same provider selections were in the provider dropdown in ssis but same error.  Maybe I didn't install the right package not sure
0
 
slightwv (䄆 Netminder) Commented:
I'm not a SSIS Expert.  Hopefully one will arrive soon.
0
 
sbornstein2Author Commented:
thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now