(I previously posted this in sqlserver.datawarehouse with no answers. Please
excuse my crosspost - I really need this to work...)

Hi, I'm trying to write a MDX query resultset from a cube to a database table
via an SSIS package. I create an OLE DB source in a data flow and choose OLE
DB Provider for Analysis Services 9.0 as the connection manager. Then I run
it through some node afterwards but it's the OLE DB source node that's giving
me a headache.

Once run it gives me a...

[Source - Query [1]] Error: An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB
Provider for Analysis Services 2005" Hresult: 0x80004005 Description:
"Server: The operation has been cancelled.".

and...

[DTS.Pipeline] Error: component "Source - Query" (1) failed the pre-execute
phase and returned error code 0xC0202009.

I sould say that the query is quite heavy.

Can anyone help, thank you!

Jacob