Thanks for your help

Thanks Megan. Do you think that applies if I'm running Report Builder on a server running SQL 2005 but using a SQL 2000 database on a different server as the...

Phew, I'm not going mad then. But I agree most of the questions are a great way to start the brain in the morning.

I've actually fixed it myself. Looking in the Event Viewer on the server, it was complaining of insufficient memory. A quick reboot of the server seemed to do the trick...

Have you checked that your OLAP Repository database is ok. I sometimes find that mine loses its data from the server table and that can cause weird OLAP errors. A...

On your old server, had you migrated your repository from the msmdrep.mdb file to a SQL database. If so on a fresh install of AS, it will create a new...

For Skip,

I've had problems with cube building DTS packages called from other scheduled packages and overcome them by ensuring that all the steps of the cube package and in fact...

If it is a scheduling problem, it could be a permissions issue with your SQLAgent account, as it is this that executes your jobs. Your SQLAgent account should be in...

Ok, I'll have a go. Thanks

This is a long shot. Have you migrated your OLAP Repository from it's .mdb file to a SQL Server DB. If so sometimes the Server table becomes empty and this...

I've reinstalled and readded SP1, but its still a no go. I wondered if it might be a dts dll problem, so I reregistered dtspump.dll,dtsffile.dll,dtsui.dll and dtspkg.dll to no avail.

...

All that appears is a message box entitled DTS Designer Error and the text inside is

||||||||||

Informative isn't it!

Dave