65008233

Date: 2020-11-25 15:59:54
Score: 8
Natty: 4
Report link

Please could someone help me on similar/same issue?

My environment situation is:

I have installed:

and

(I have tried multiple time installing only 32 or only 64 versions, and uninstalling and restarting VMs) I have SSIS package with Oracle Connection Manager. In Visual Studio inside package:

  1. Connection manager to oracle test: SUCCESS
  2. Run Package: SUCCESS
  3. Deply Package to SSIS DB: Fail (Reasonable -> I have SQL 2017 :)

  1. IF SQL Target version is SQL 2017

  2. Connection manager to oracle test: SUCCESS

  3. Run Package: FAIL

    ERROR in DEBUG MODE:

[OMS OrderLines ABBICS V_F_ORDERS_RO24881SRU 2] Error: The AcquireConnection method call to the connection manager Oracle DB failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: OMS OrderLines ABBICS V_F_ORDERS_RO24881SRU failed validation and returned error code 0x80004005.

Error: The ORACLE registry key cannot be opened. Verify that the Oracle Client for Windows x86 is installed properly.

  1. Deply Package to SSIS DB: SUCCESS
  2. Run Package on SQL Server (from SSIS Catalog or from JOB): FAIL -> Basically same errors as in package

I have tried running packages in 64 and 32 bit mode as well as running job in 32 bit mode. The onlly diffrence was

...Windows x86 is installed properly...

or

...Windows x64 is installed properly...

Thank you! Wojciech

Reasons:
  • Blacklisted phrase (0.5): Thank you
  • Blacklisted phrase (1): help me
  • Blacklisted phrase (0.5): i need
  • RegEx Blacklisted phrase (3): could someone help me
  • Long answer (-1):
  • No code block (0.5):
  • Me too answer (2): same issue
  • Me too answer (0): same error
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: wojjy