Reply here - http://www.sqlservercentral.com/Forums/Topic426779-146-1.aspx

OOOOhhhh,

You really should have checked this one out before you did it. Basically you cannot process AS2005 cubes from DTS.AS 2005 has been completely re written. You should notice that...

Hi,

It should be fine in a SQL task! can you paste teh full error message for us. Have you googled the error message?

Sean,

If you are wanting the entire cube to just have 1 weeks worth of data I would suggest doing the folowing. I would recomend that the fact table you are...

I agree with Chris. The migration wizard "may" get the cube across but when you start to edit it you'll find its done a shoddy job of it, Hirerachy and...

Fortunatly we have a SAN and this is our first Itanium so have no previous knowledge of the set up joys that come with them.

Thanks SK

My kids are past the age now but a Crèche would have been wonderful.

If you cant upgrade without destroying the original data in the cube there could be another option. Depending on the complexity you could MDX all the data out. I've done...

Steve,

According to the Wrox gurs "Analysis Services 2005 provides you with the option of storing the data or aggregated data efficiently in a propriety format on Analysis Services instance or...

There is a migration wizard "migrationwizard.exe" but dont hold your breath that it will work.

We've done this as well and havnt had a single problem, not like we have trying to migrate 2000 cubes to 2005.

Hang on SQL Noob, the "S" key is no where near the "I" key!!

SQL Noob,

What makes you say that?

Not sure if you already have this but I've fount this System Table Map a god send sometimes, it helped me when I was doing something similar.

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

and download