Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLAP Services process through DTS hanging

Status
Not open for further replies.
Apr 30, 2001
8
0
0
GB
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top