error opening a SSIS package

Question

Viewing 7 posts - 1 through 7 (of 7 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Sounds like you are missing the MSORA Driver that the connection is using.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

bryan72florida Grasshopper Points: 24 More actions · Answer 2

is there any way I can get the MSORA driver ? If so can you give me a little help on how to do it ??

Thanks a lot btw

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

32 or 64 bit?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

bryan72florida Grasshopper Points: 24 More actions · Answer 4

Grasshopper

Points: 24

May 21, 2011 at 8:57 am

64

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

bryan72florida (5/21/2011)
is there any way I can get the MSORA driver ?

I forgot to ask you what version of Oracle you are using?

I noticed this old article about this issue.

I need to take care of something.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

I prefer the Oracle Driver over the Microsoft Client Driver.

What is installed on the machine in which it is created?

For instruction on installing the Microsoft OLE DB Provider for Oracle:

You may want to check out this article (FYI):

To download the driver:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/