Thanks for all the replys, I did a resotore from the cab file and everything works great so I'm feeling better about the whole process.  I am going to keep...

I noticed that when you manually archive a database it uses the path

"C:\Program Files\Microsoft Analysis Services\Data\myCubeFolder"

This folder contains a whole bunch of files and is obviously the reason for the...

Ya I didn't think there should be a difference.  Yes I am comparing the cab1(~300kb) build within MMC to cab2(~7kb) built using msmdarch.  I guess one way to test it...

I have resolved the issue.

Do you have the appropriate users setup in SQL Server (sa, BUILTIN/administrator)?

Which account did you find SQL Server Agent runs under?  SYSTEM ?

Thanks for the post that's exactly what I was looking for!

Fantastic!  Thank-you. 

You wouldn't happen to have an example on how to call a dts package from a stored procedure?

I thaught it might have just been a referance to the original.  Thanks for the reply.