OLAP Services process through DTS hanging

[AlexHeddell]

I am processing 5 cubes through a DTS job. Three of the cubes process fine and then the job hangs on the fourth

Any clues?

Cheers

Alex

 

[issahar]

Hi, Alex.

Which Olap version are you using?

Do you try to do this via the Vbscript of the dts or via the OLAP services package?

Is Sql server olap 7.0 Sp3 Installed in your server?

My best regards, Issahar

 

[AlexHeddell]

Found this one. I am running SQL7 SP3 and OLAP SP3

I was using the OLAP services Add-in to schedule the jobs. If you save the jobs as 'SQL 2000 encryption', they hang. If you take this off, they work.

Cheers

Alex