Does the package have multiple tasks running in parallel?

Run them in serial to minimize the memoery used.

You can find the processing time only in the processing log, if you have enabled it.

It's a text file, look for a line something like this:

8/12/2005 1:50:07 PM 4947     Completed Processing Cube 'CubeName'....

Member Names Unique deals with all members in the dimension, but it won't for duplicate names in the same branch (with the same parent).

No, when you import a calculated member into the virtual cude, it creates a copy of the calculated member, so the formula exists in to places. If you change one,...

To move the current db just copy the files to new location.

DTC has to be running on all three servers, instance A, instance B and the server with client tools only.

have you tried to full process the cube?

Does the user that you use in your DTS have access to the share?

This may help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

May be the path where the cmd is executed, try specifying the destination:

/c "copy c:\AZSCHMEMBERSHIPvvvvvvv.csv+c:\AZSCHMEMBERSHIPvvvvvvv.Detail c:\AZSCHMEMBERSHIPvvvvvvv.csv"

Install Pivot Table Services on the machine with Excel, it's on your installation cd or service pack. Be sure to install the same version than the server, e.g. if server...

Also, check your queries to see if they are using indexes or if you need to redesign them.

Here are some links:

http://www.mosha.com/msolap/

http://www.sqlserveranalysisservices.com/

http://www.databasejournal.com/features/mssql/article.php/1429671

http://www.databasejournal.com/features/mssql/article.php/3080511

And it still gives you the error?

Try to browse the dimension from the cube.

You have to process the cube, too.