I'm trying to run a SQL Server 2008 SSIS package in Visual Studio 2008 using Attunity 64bit to talk to an Oracle 11g database (CPPROD). When I execute the package manually I get the following error:
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0x20F at Data Flow Task, Oracle Source : The AcquireConnection method call to the connection
manager Oracle CPPROD Connector 1 failed with error code 0x80004005.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "Oracle Source" (321)
failed validation and returned error code 0x80004005.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package.dtsx" finished: Success.
I am using SQL Server 2008 Enterprise Edition 64 bit, Oracle 11gR2 Client 64bit, Attunity 64 bit, Visual Studio 2008 64 bit, all on the same server. I am unsure where the problem lies - can anyone point me in the right direction?