Viewing 15 posts - 1 through 15 (of 23 total)
GloriousRuins (4/30/2015)Could anyone help me with issues I'm having with the reverse scenario
That's exactly how you should do it so, the issue that you're having may be related to something...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
May 22, 2015 at 4:12 pm
In order to do a script task, you'll definitely need Excel installed (since it has to open an Excel session in the background) so, that's not a viable option for...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
May 30, 2013 at 12:12 am
I'm not sure you can do this with XLSB. XLSX and XLSM are basically the same - XML-based files. XLSB is a binary format, which is closer to...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
May 27, 2013 at 5:23 pm
On the Design tab, go to your Row Groups section (bottom left pane of the Design tab) and right click on whichever group you want to page break by. ...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
December 18, 2012 at 1:46 pm
That's exactly right. The connection manager file selection window won't let you complete the action unless you select a valid Excel file. This can be any Excel xlsx file. Once...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
March 14, 2012 at 3:23 pm
For starters, your Connection string under the Excel connection manager should look more like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=drive letter:\your file name here.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES";
The above should have been automatically generated by...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
February 13, 2012 at 1:23 pm
Performance tuning depends on which of these three is holding up the report:processing, Data retrieval, or rendering. You'll notice that the report will run those three tasks in that...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
February 11, 2011 at 11:05 am
I had the same issue with pulling ~30k records from a stored procedure. Data retrieval and rendering time grew in a linear fashion as row counts went up and...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
February 9, 2011 at 5:53 pm
i don't have it in front of me, but there is a 64-bit ADO.NET driver. I don't remember what it comes up as in the menu, but it's there and...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
October 26, 2010 at 10:01 pm
I've had openrowset do some very weird things when connecting to an Oracle database, so I've generally steered away from using it in general. Overall my conclusion is that the...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
October 26, 2010 at 9:43 pm
Here's the main downloads page:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
If you click on see all next to Microsoft Windows (x64), it'll take you to this page:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
The second section contains the Client...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
October 20, 2010 at 12:29 pm
You can do something like this by setting up linked servers on your 1 data source server. Once you do that, you can write your code referencing the linked...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 28, 2010 at 3:06 pm
Technically, you can't delete records - you can only empty them out using an update statement like this:
update table_name
set field1 = null,
field2 = null,
fieldn = null
where field1 = unique_value
Obviously, not...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 28, 2010 at 3:00 pm
Do you have the 32-bit version of Oracle Client 11g R2 installed or the 64-bit? Are you able to establish a connection to the Oracle server from Windows 2008...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 10, 2010 at 4:38 pm
If you're familiar with T-SQL (Microsoft) then PL/SQL (Oracle) shouldn't be too much of a stretch. If you're not familiar with either, then, well you'll need to pick up...
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
July 10, 2010 at 4:28 pm
Viewing 15 posts - 1 through 15 (of 23 total)