Hi, I have SSIS package which is created to pull data from oracle server. The package is running fine when executing from BI studio. But failing when i execute as a job. I am getting teh below error message. Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client and networking components were not found. 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 components are installed.". End Error Error: 2007-10-15 16:04:15.60 Code: 0xC020801C Source: Data Flow Task O... The package execution fa... The step failed. Appreciate if somebody can provide some inputs on this .

Are you running it on the same box? Are you running on 64-bit?

Hi Akshita, Try installing Oracle client on the machine. Regards, B@ns

I have already installed oracle client on my PC and the package is running fine. But our DBA has isnatlled oracle on server side . So when I run SSIS package as job it runs only on server side. So it doesnot matter if I isntall oracle on my PC or not. The SSIS package is running fine from BI studio but failing only when I run it from SQL agent.

akshita wrote: I have already installed oracle client on my PC and the package is running fine. But our DBA has isnatlled oracle on server side . So when I run SSIS package as job it runs only on server side. So it doesnot matter if I isntall oracle on my PC or not. The SSIS package is running fine from BI studio but failing only when I run it from SQL agent. See John's note above. Is the server a 64-bit machine?

Phil Brammer wrote: akshita wrote: I have already installed oracle client on my PC and the package is running fine. But our DBA has isnatlled oracle on server side . So when I run SSIS package as job it runs only on server side. So it doesnot matter if I isntall oracle on my PC or not. The SSIS package is running fine from BI studio but failing only when I run it from SQL agent. See John's note above. Is the server a 64-bit machine? Also, have you verified that the Oracle client installation is working properly on the server? Can you connect from other tools?

Yes it is installed properly. I tried to query from sql plus utility and able to get results. But still could't fine the solution.

akshita wrote: Yes it is installed properly. I tried to query from sql plus utility and able to get results. But still could't fine the solution.One more time. Is the server a 64 bit machine or not? Yes or no?

Yes.It is . But can explain how it matters for 32 bit or 64 bit machine.. just wanted to know..

If you are running on a 64-bit server, SSIS runs in a 64-bit mode by default. That means you have to have the 64-bit drivers installed for Oracle. If you don't have the 64-bit drivers, you can force SSIS to run in 32-bit mode by calling the DTEXEC.exe located in C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn (default location - may vary depending on your install). You'll have to use a CmdExec step type in SQL Agent to call the DTEXEC executable directly. If you use the SSIS step type, it calls the 64-bit version.

I am running on 64 bit machine. But the prob is resolved now. OIur DBA changed some enviroinmental variables and now its working finr. Anyways thanks for all your inputs

hello i am getting the Oracle error above when executing dtexec.exe from within sql agent job. i am running a 64 bit server but the package was designed on my desktop. it works fine in BIDS and also works when deployed to MSDB by right clicking and choosing run package. I have the oracle client installed on the server. can anyone help please?