The link that Michael provided is certainly a good place to start. The Oracle Database Release 11g R2 is currently the latest release, and will probably work for you....

It turns out that the server had the WebClient service disabled, so it wasn't recognizing the unc path regardless of the fact that I was authenticated to it.

In short, uploading...

I finally figured it out! The 11g R1 32 bit client succeeded where the R2 client failed. I cleared out the existing installations, installed the 32 bit 11g...

I don't think that this is applicable. The Sharepoint Connections for SSIS (which I have), are meant for Sharepoint List data transfers. From what I've seen, this is...

This is an IIS 6.0 setting, correct? Can you give me a brief how-to in making this change?

Also, I should not that the ADO.NET driver (provided by Microsoft) is...

To connect to an .xlsb (or .xlsm) file, you must first set your Excel Connection Manager to point to any generic .xlsx file on your computer (create it if you...

The string looks the same (has the 12.0) in BIDS. Whenever I have the 32 bit driver installed, the SSIS package in BIDS validates just fine. Whenever I...

Thanks, Todd. You may be referring to me naming the connection "Excel 2007 Connection Manager", which may be a misnomer since I'm using the 2010 drivers.

I took a look...