|
Home > Archive > MS SQL Data Warehousing > December 2005 > MDX resultset in SSIS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MDX resultset in SSIS
|
|
| Jacob_I 2005-11-29, 3:23 am |
| 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
| |
| Jacob_I 2005-12-02, 11:23 am |
| Hi,
Is there really no one who can help me here? I would really appreciate it.
Alternatively, maybe someone could tell me where/to whom I might pose my
questions.
Thanks a lot.
/Jacob
|
|
|
|
|