Process Cube using SQL DTS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brettos - 30 Nov 2004 16:01 GMT

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

Reply to this Message

James Ma - 07 Dec 2004 23:49 GMT

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

James Ma

> Hi
>
[quoted text clipped - 17 lines]
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message542345.html

Reply to this Message

Dennis Redfield - 08 Dec 2004 14:53 GMT

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

> Hi
>
[quoted text clipped - 17 lines]
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message542345.html

Reply to this Message