If you run the following query at the msdb database (one of the system databases) at your SQL Server, do you get any results?

SQL Server 2005:

SELECT [folderid]

...

Ragie,

I've had a similar issue not so long ago.

I was also looking for a clean way to 'exit the loop' if an error was found (similar to the continue statement...

You could also send the execution command directly to the server. Something in the like of:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /SQL "\Folder\MyPackage" /SERVER "MyServer" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF...

Hi.

I recreated your problem in one of my cubes.

I added a calculated attribute 'Test' as day(Calendar_Date) in my time dimension.

I did this in the data source view by using a...

Did you try re-starting the Integration Services-service in SQL Server Configuration Manager?

Some basic questions to start with (some may even seem stupid :))

* Did you deploy the cube to the right destination on the server?

* Has your connection manager in BIDS...

Try to get your hands on the book "Professional Microsoft SQL Server 2008 Integration Services" from Wrox.

It provides you with a thorough overview of SSIS, together with a lot of...