Recursive? Are you seeing something I'm too dumb to realize?

From a sql-server-performance posting (edited):

Carl Federl (11/16/2005)

---

I may change my mind on UDFs.

I am in the process of writting an article and a set of test cases but here is...

If you chose to go direct to the Excel Pivot table, use Pivot Table Options, and select "Refresh on Open." Not quite the same as an automatic update, but who...

You should not need the package. Just open Excel and create a pivot table using an external data source (your view in your server).

Or am I missing something?

But that seems to be the DTS/SSIS error. Have you just tried to get the pivot with a direct load from Excel?

What type of error did you get trying to load the pivot table directly?

How many rows are you working with?

In Excel, create a pivot table (Data/Pivot Table and Pivot Chart Report...) and choose an external data source ([External Data Source] -- your table/view). The data can exceed the maximum...

Another consideration is the source of the data -- the source of our DB data is a mainframe (non-relational) application from which we download biweekly. In that situation, foreign key...

1. Using Windows authentication, there is no need for Excel to cache the credentials.

2. There is no need to run Excel on the server in order for an...

Set the Excel External Data Range Properties to "Refresh data on file open", and your government users (like mine) will not even know the difference. If you want to...

Let Excel pull the data instead. Create your Excel workbook using external data, and set the Data Range Properties to Refresh data on file open. (Give your user select access...

I'd be inclined to let Excel (and the users) do the work and pull the data rather than you pushing it. If, on a worksheet, one creates a pivot...

That sounds like a task for Excel (or Access). Have you tried an external query from Excel (using either the query wizard or MS Query, which is a part of...

I've never seen the funnel icon enabled. What is your secret?

The culprit has been found, and it seems to be Microsoft!

When I went to forward the ill-formed issue back to you folks, Outlook insisted that I load the pictures...