1

I must develop a SSIS Package with Oracle connection. I'm using Windows 8.1 64bit with Visual Studio 2010 and Oracle version 12c(remotely).

I would use "Microsoft OLE DB Provider for Oracle" like picture: enter image description here

Where I insert my connection parameters: enter image description here

After "TEST CONNECTION" command I get this error: enter image description here

[UPDATE]

After installation of ODTA 32bit I can test my connection, but when I try preview result of Data Source component, I get this error: enter image description here

[UPDATE-SOLUTION] I've resolved this problem setting this parameter equal true: enter image description here

Why I get this error? How can I resolve this problem? Thanks

Improve this question
2
  • 1
    We found the MS driver for Oracle to be slower compared to the one provided by Oracle. If you have it installed, just scroll down, and choose "Oracle provider for OLEDB" Commented May 12, 2015 at 14:42
  • Hi Raj, thanks for your hint. I have not this driver installer. I would not execute hard operation, my priority is make working my package. :-) Commented May 12, 2015 at 14:46

1 Answer 1

Reset to default
0

You need to install 32-bit ODAC 12c for Windows x86.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Hi Stefan, I've installed ODAC 12c for Windows x64 but I have the same error.
Ok try to install the 32 bit version. I think Visual Studio is a 32 bit app.
Hi Stefan, I've added new details about this problem. After your hint I can test my connection with success but I can't preview data from Data Source component.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.