Is it possible to use DTS to extract data from an Analysis Services Cube and
to put the resultant data into a fact table in another star schema.

Something similar, I use a UDL through a Data Link connection, set to use
the MS OLAP OLE-DB provider. I can then consume this with a DataPump, using
an MDX based query, and pump the data into a SQL table.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Tom M" <TomM (AT) discussions (DOT) microsoft.com> wrote

How do you configure the data link. The cube that I am extracting from is on
a separate server from the destination database.

"Darren Green" wrote:

I just follow the GUI prompts. I am normally all on the same server, but
pretty sure it works cross machine, as I would have developed the
package against the remote server on my workstation. Shouldn't be a
problem. Do you have an error?

Darren Green
http://www.sqldts.com
http://www.sqlis.com

Tom M wrote: