How to import cube definition from SSAS 2000 to SSAS 2005

Hi.
I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done? Any suggestions would be greatly appreciated!

Regards
Kjetil

AS2005 won't read the backup files produced in AS2000, but AS2005 comes with MigrationWizard.exe that can be used. You will need to:
- have AS2000 running and containing the database you want to migrate
- run MigrationWizard.exe, specify the source AS2000 and then you can decide to migrate directly to an AS2005 or to just generate the migration script (and XML/A script that you can later run on AS2005 with SQL Management Studio)
- you will need to reprocess the database on AS2005

Adrian.

|||Hello Adrian,

I tried your solution but I still have a problem.

In my case the MSAS 2000 (with cubes) is on a separate server. I can connect and start the wizard but when the wizard is checking the data source it fails.

CONFIG:
Server #1: MS SQL Server 2000 (SP4) + MS AS 2000 (SP4)

Server #2: MS SQL Server 2005 + MS AS 2005

I have a local account on Server #1 and a local account on Server #2. Both same name + password.

The DTS-wizard is working fine, but the MSAS migrationwizard not.

Any ideas?

Thanks in advance for any help.
Marco.|||Hi,
The error occurs in the validation page (where there is a tree with the AS2000 objects) or on the next page (migration page - where the script is being sent to AS2005) ?
Can you please post the error ? Or the log if the error occured in the validation page (there are some buttons under the tree, one can be used to get the log).

Thank you,
Adrian Dumitrascu.|||Hello Adrian,

Thanks for your reply.

My first server (SQL 2000), SERVER#1 is on domain AAA.DOMAIN.COM
My second server (SQL 2005), SERVER#2 is on domain BBB.DOMAIN.COM

The message I get is: Source server: The following system error occurred: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Any suggestions?

Why not just easy use the .CAB file?

Thanks in advance,
Marco.|||Thank you!
Sorry for the delayed reply but I'be been rather busy lately.
I am starting on this project next week and will try out your suggestions.

Best regards
Kjetil