You can use a linked server or a UDL to specify the OLAP Provider and query
your cube. This is used as the source for your DataPump task.


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

"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote

Hello Darren,

First of all, thanks for your reply.

Can you please explain what you mean with "a linked server" and "a UDL".

Are these a sort of "tasks" I can define within the DTS?

Thanks in advance.

Regards,
Marco.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

For more information on linked servers try looking up sp_addlinkedserver in
the index of Books Online. You can also use OPENROWSET, again found in Books
Online.

For some examples of this in the context of OLAP try this KB-

HOW TO: Perform a SQL Server 7.0 Distributed Query with OLAP Server
http://support.microsoft.com/default...b;EN-US;218592


A UDL or a DataLink is a small file that is basically a connection string.
DTS has a Data Link connection.
UDLs can connect to the OLAP provider in a similar way to that described in
the KB above. To create a UDL, create an empty text file, and rename it to
have the extension udl. Now double click on this file. You can select one of
the MS OLAP providers from the "Provider" tab.


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

"Marco Linders" <m.linders (AT) pforb (DOT) com> wrote