Viewing 8 posts - 16 through 23 (of 23 total)
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....
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 10, 2010 at 4:20 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 23, 2010 at 2:41 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 9, 2010 at 4:44 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 7, 2010 at 1:52 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 7, 2010 at 1:22 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 4, 2010 at 2:04 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 3, 2010 at 3:48 pm
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...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
June 3, 2010 at 11:13 am
Viewing 8 posts - 16 through 23 (of 23 total)