DevOps, CI/CD and Automation

I’ve successfully run this process below on a Windows 2003 32 bit SQL 32 bit development server with the exact same installation steps and TNS file. I’m ready to move this to our production x64 server below...

In production I’m trying to run a SSIS package using OLEDB Oracle provider on Windows 2003 SP2 x64 SQL Server 2005 x64 to connect to an Oracle 10g x64 server. I receive the following error when I Test connect in SSIS:

“Test connection failed because of an error in initializing provider. Oracle client and networking components were not fount. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these are installed.

I’ve installed the x64 Version of Oracle 10g with
1. Oracle Net Services (Net, Net Listener, Connection Manager)
2. Oracle Windows Interfaces (OLE DB ODBC)
3. SQL Plus

I’ve used the same TNS File in development and copied it to production \Network\Admin\

I can connect from SQL Plus on the production SQL Server to the Oracle 10g server using the TNS Service name.

I’ve checked the Environment Variable PATH on the Windows Server to make sure it includes the path to the Oracle Home BINN folder

The Oracle Home folder has everyone FULL permission configured.

I’ve un-installed and re-installed Oracle 10g with a reboot in between.

Windows COM+ Service is running

I’ve verified that I installed the 64 bit version of Oracle on the 64 bit server.

I’ve tried to compare any and all settings between the successful development server and the production server and things all look identical since I’ve taken the defaults for everything. Though every time I try to make an OLE DB connection I get the error above. On the development server I do not, it works great. I need to use OLE DB in SSIS since that is how I’ve defied all of the steps in the data flow. Does anyone have any other troubleshooting ideas or tips? I’m fresh out of ideas at this point…..