Interesting article. I'm wondering why you chose SSIS instead of SSRS for this task. SSRS seems tailor-made for this.

Mike Hayes

We addressed this issue by creating a view in SQL Server that displays the requested data, and giving the users the rights to select from that view. Excel can...

What does the log say?

It sounds like the Excel export is using all of the available memory. This would be happening on the server side. How many rows are you attempting to...

When you say it's not working, what's not working? It doesn't work at all? Do you get an error? What?

Mike Hayes

Check out Reporting Services Scripter: http://www.sqldbatips.com/showarticle.asp?ID=62. I haven't used it, but I believe that it will move subscriptions.

Mike Hayes

You can work around the limitation in Excel 2003 by breaking up the report into multiple tabs. On the table properties, go to the Groups tab and add...

This is written from the other perspective, but you still might find it useful:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorcle.mspx#EWBAI

Mike

I'm finding documentation on this functionality in Oracle, but not SQL Server. Is this supported in SQL Server?

No. You don't have to create two versions of the same report. Just create two schedules. After creating the first schedule, go back to the Subscription...

Try something like:

SELECT

SUM(CASE WHEN age>=60

THEN measure ELSE 0 END) AS over_60,

SUM(CASE WHEN age>40 AND age <60

THEN measure ELSE 0 END) AS over_40,

SUM(CASE WHEN age>18 AND age <=41

THEN...

A quick way to divide the problem in half would be to temporarily add the user to the administrators group on the PC.  If this takes care of the problem, ...

While doing installs of Reporting Services recently, I came upon an issue that caused errors similar to the one you describe.  Try the following:

Check properties of Reports virtual directory.

 -Right-click My...