The OraOLEDB issue on BIDS & SQL Agent under 64bit Windows system is kind of famous issue..

Recently I found the solution that works for me.
That is installing Oracle 32bit & 64bit both clients in the server what sit on 64bit Windows system.
I run SSIS, Linked Server, VB, C# and SQL Agent under 64bit SQL Server for some Oracle database interaction and all of them works fine!

You can find the exact steps in here.
http://knol.google.com/k/jeyong-park...rce-from-64bit





Posted as a reply to:

Re: Can't get Oracle OLE DB provider to work from SSIS on a 64-bit environment
18-Apr-07

Hi Russel,

Thanks for the link. I have been through that topic though and it
doesn't seems to help me a lot. The project I'm trying to get running,
consists of approx 25 seperate packages where 3-4 of them gets data from
different Oracle sources, but I'm not even got to the point where I'm
trying to run the whole lot.
So far I'm only testing the data sources set up, and here it fails
already when I try to edit a Data Source or create a new one and do a
"Test Connection".
There are two issues in the topic that could be an issue, and that is to
switch the whole project to 32-bit mode and then the part that says that
the Designer only shows 32-bit versions of the provider.
I have switched the project to "32-bit mode" but that didn't made any
difference. What I think I'll try now, it to install the 32-bit version
of the Oracle ODAC to see if that makes any difference. I'm not wuite
sure if that will invalidate the 64-bit version I've installed, but I'll
have to see..:-). If I can get that to work, then at least I know I'm on
right track and then I'll take it from there.

--
Regards
Steen Schl?ter Persson
Database Administrator / System Administrator


Russell Fields wrote:

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx