I agree with the "nice" part, but it's not an easy one if you don't regularly poke around altering tables, using transactions etc.. (judging by the figures: 50% wrong, it...

As this is the Integration Services forum: I suggest you build a SSIS package to import the data from the excel file into the appropiate tables.

If needs be, you can...

Nice question! It made me do some reading-up on a feauture I've never used so far.

Allways good to refresh those areas once in a while.

Really like the "none of the...

I agree with Bob: how should we know which date 40358 is, without executing a command?

Poor question, poor explanation as well (as pointed out in some other reactions).

Well, If you can find a good example of the script you can easily go from there.

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/28/SSIS_3A00_-Building-Packages-Programatically.aspx might be a good place to start your search (maybe a little old).

The...

Hard to guess what exactly is happening there, but could it be that your asp.net app is trying to connect to SSRS under its own credentials (the account running IIS),...

I agree with Daniel that it is better to create a couple of data-driven subscription by hand, and then just manipulate the data for the data driven subscriptions form your...

As metadata in a package can not be changed while the package is running, you should create a package "on the fly" with the source and destination you need, validate...

If I recall correctly someone (might hav been Chris Webb) said in a PowerPivot-demo that it was important that your keys are a single, numeric column. I don't recall the...

In my opinion SSRS is not the right tool to solve this.

You could trick it for one record at a time by having a special report where the user-input is...

This is indeed a simpler example than the ones I have seen before, as it requires no codebehind on the report.

There is one pitfall however that should be noted: the...

It is a long shot, but is there a 2008R2 SQL Server instance installed on your ReportServer for the SSRS-db's?

If so, you could consider creating a linked server on...

The problem you are experiencing is due to the fact that in SSRS the dataset from the cube is imported as-is, and further used ïn a way similar to a...

My guess is you should put the two charts in one rectangle to keep them together, even when the report is expanding to the right.

This works splendidly in SSRS 2005,...

You should look into using runningvalue instead of sum in you calculation, corrected for the value in the current month (because you want the standing at the beginning of the...