sql server dts: Is it possible to process Analysis Servies 2005 cubes from Analysis Services?

We are currently moving our existing 2000 cubes over, but there are a number
of DTS packages that we would like to be able to continue to use until we can
move those to SSIS but one of the things DTS does is process the cubes on a
scheduled basis. Is there a way that we can continue to use DTS to

Hello Amadeus,

Initial inspection says that it will not be possible to process the cubes
from a DTS OLAP task in a 2K package. If you have a Side/Side installation
you may be able to


1. Call AMO from an Active Script task.
2. Execute a batch file or external piece of VBSCript from an Execute Process
task that does the processing.

You could also remove the processing of the cubes from the packages for the
time being and move that step to a SQL2K5 job and then reunite them once
you have migrated to SQL2K5.


Allan


[quoted text, click to view]