That's exactly how you should do it so, the issue that you're having may be related to something...

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...

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...

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. ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...