I'd be interested to know if this has changed at all in SQL 2008, however when we needed to pass variables in our source queries against an Oracle instance in...

You can use SQL Agent for this

Go to the Agent running on the relevant server where your SSIS packages are stored and select New Job

Under the job steps, you add...

I agree that MSFT still have some work to do in terms of giving us the ability to report off OLAP cubes in SSRS.

If you have Excel 2007, Marco Russo...