Insert MDX result in SQL Table ?

[Recce]

Good day,

I have some simple MDX caode that I use on some of my cubes however, I am trying to run this code and then return the results into a table. I don't seem to get this right. Would anyone perhaps have an example of a simple piece of code that will show me how to do this ?

Thanks

"We know nothing but, that what we know is not the truth..." - Me

 

[MDXer]

You can use either open query or a SSIS package to do this. I can't tell you how to do it through open query as I use the SSIS solution myself.

 

[Recce]

Hi MDXer,

Yes, I would prefere to use SSIS. Can you suggest a place where I can see an example or two ?

"We know nothing but, that what we know is not the truth..." - Me