sql server data warehouse: Process Cube using SQL DTS -- sql server data warehouse

Process Cube using SQL DTS

brettos
11/30/2004 10:01:43 AM

sql server data warehouse:

Hi

I have created a package to do this which simply returns with the erro
'1 task(s) failed during execution'. I can process the dimensions an
cubes manually in analysis Manager fine.

SQL and analysis Manager are both on the same server and the tas
appears to be running with the domain administrator user.

Cany anyone help?

Cheers

Brettos

-
bretto
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message542345.htm

RE: Process Cube using SQL DTS

James Ma
12/7/2004 3:49:09 PM

In workflow properties, set "Execute on main package thread", including all
packages that contains OLAP processing.

James Ma

[quoted text, click to view]

Re: Process Cube using SQL DTS

Dennis Redfield
12/8/2004 9:53:12 AM

To help in your debuging.
Open The package in design mode.
Right Click and Select "Package Properties"
Select The "Logging" tab.
Provide a log file location to use during processing of the package.
save and close the package.

Now run the package.
Open the log file and see what details you can gleam.
report back to us.

Hope this helps.

dlr
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.