Forgot to mention that it is SQL server 2008 R2 64 bit.

I had to install both the 32 bit 11g Oracle Client to work with BIDS and the 64 bit...

I ignored the warning and it sucessfully installed. Thanks.

What type of an Account are you using for the SQL Server Agent Account?

Permissions...:-)

I attempt to install the 64 bit version after installing and removing the 32 bit version due to a bug and I get the space error again.

It's a bug, you must install the 64 bit first and then install the 64 bit.

I have resolved the issue. Someone copy a SQL Server Installation into that folder.

I run the install and I get this error.

I don't remember how to correct the problem?

Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH"...

To get the download to work correctly I had to Click Open as opposed to Save and then Save the files.:w00t:

Installation in progress... Now comes the fun part.

I download the 32 & 64 bit Oracle Client Zip Files, attempt to extract and I get a message that they are empty.

I downloading from Oracle's Web Site.

I'm don't understand...

I found an article that confirms that the 64 and 32 bit Oracle Client must be installed.

http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

I found that the Installation for the Oracle10g Provider for OLE DB is probably what I need.

The download is at the following location:

http://www.oracle.com/technetwork/database/windows/utilsoft-088126.html

I run the install and I get...

Double post.

Jan.Sundbye (7/3/2012)

---

If my memory serves me right I think you need both 32- and 64-bit Oracle Client. If you're using BIDS (32-bit)you need 32-bit client to connect to the Oracle...

One Alternative to an OLEDB Source & Destination would be to setup a Linked Server and use OPENQURY.

I prefer to specify the Fast...