Spam - a - lot

There are a number of good tutorials online about creating package configurations. I would suggest using a database, because then you could create a small application or another package...

From the looks of things you have some kind of date value to load data for a week. In your query, rather than use a fixed date parameter like...

Saturn V

I would probably do this with a little more work in the dataset. First start by adding some quarter definitions to your data. Then I would use a...

I can't believe I ate the whole thing!

Drive safely

If your tabs are consistently named you should be able to create a variable that uses an expression for its value. Create an expression that builds the appropriate tab...

eggs

PerformancePoint is a pretty good dashboarding tool, but I believe requires Sharepoint. If you are going to be using 2012 you might also want to look into PowerView. ...

Best for what? Performance, data integrity, minimal impact on the source system.....the list goes on.

brain fog

Slinky

It sounds like you are trying to create a data driven subscription. Do you have the enterprise version of SQL Server?

Not sure exactly what you mean, but assuming you want a subscription to fire off as the result of a stored procedure, or other command. You need to kinow...