Proceesing cube using analysis services processing task

Hi,

I have a dts package stored in sql server 2005 which has a analysis service processing task to process a cube stored in sql server 2005 itself.

whenever i try to execute this package it crashes the sql server management studio and in the logfile i can find the error operation has been cancelled.

When i try to process the cube directly it processes without any problem and i can browse and see the data also.

In the package i am trying to do full process of the cube.

Also the cube and the package are migrated from 2000 to 2005.

The onemore problem is after migrating the package i am unable to see the cube setting also

Please help me to solve this

Thanks in advance

Mervin

Analysis Services 2005 uses completely new management object model: AMO. The old object model: DSO used in DTS processing packages although supported, requires from you to go through additional conifugration process.

You should try to create a new SSIS 2005 package to process your AS 2005 cube.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

thanks you i will try this.

But if i want to keep the dts packages itself what kind of configuration process i need to add.

And if i try to create the new packages i am not clear about the processing options that are to be provided

for the refresh data and rebuild dimension structure of dts.

Regards

Mervin

|||

Full process is going to rebuild dimension stucture

Process Update will refresh data in your dimension.

Here is whitepaper talking about processing options in Analysis Services 2005: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.