I am using an SSIS Package to get the data from Oracle DB to SQL server 2005 DB.
I am using Micorsoft OLE DB provider for oracle for creating a connection manager to connect to ORACLE 10 g.
The package runs great in my local PC. when I move the package to the Server ( Microsoft windows server 2003 R2, Enterprise x64 edition) which also has SQL server 2005 . the package fails to run showing the error: "
the AcquireConnection method call to the connection manager "HRDATA" failed with error code 0xC0202009."
I tried to see if the Microst OLE DB provider for Oracle is installed or not using the .udl file. The provider tab in .udl file does not show any provider named " Microsoft OLE DB provider for Oracle"
Can anyone please help me by telling how can I installed the Microsoft OLEDB provider for Oracle, given my server is ( Microsoft windows server 2003 R2, Enterprise x64 edition) and my source data base is ORACLE 10g.
View Complete Post