SQL Server Integration Services Wizard Oracle Provider Error

Question

SQL Server Integration Services Wizard Oracle Provider Error

webrunner

SSC-Dedicated

Points: 31862
More actions
October 31, 2019 at 2:19 pm

#3693554

Hello experts, I tried posting this in SQL 2008 because that is the SQL Server version. But I got no answer after almost 2 days so I am trying one of the more active forums. Apologies in advance for cross-posting.
I think it is more a driver issue than a SQL 2008 issue. A client reports the following error when trying to export data from SQL Server to Oracle:SQL Server Import and Export Wizard
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
Additional information:
-> Provider cannot be found. It may not be properly installed. (ADODB.Properties)The SQL version is:Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)The export option that the client chose is:Destination: Oracle Provider for OLE DB
My noob question is: Is there a specific version of the Oracle provider that I need to install on this server? Or might there be some other issue going on?
Thanks for any help.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32344 More actions · Answer 1

Provider cannot be found. It may not be properly installed-> Is the oracle driver installed on the sql server and/or the client?

webrunner SSC-Dedicated Points: 31862 More actions · Answer 2

Thank you, Jo. I hadn't thought about looking at both sides - the server and the client. I will review the providers on both and will check for the latest versions for each.

Thanks again.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

crow1969 Hall of Fame Points: 3001 More actions · Answer 3

For SSIS, make sure you have the 32-bit Oracle driver installed. I believe the wizard uses 32-bit .dlls and such.