Hello

Under SQL Server 2000 SP4 / Analysis Services I try to move an
analysis database from server A to server B.
On server A, I want to process data which comes from a SQL Server
database C, on server B the name of the (identically structured)
database is D.

How can I do this?

After restoring from a CAB file the data source may be changed but it
must be buried somewhere else in the database

Do I have to use a special provider to avoid this?

Regards
Klaus Wiesel

If you need it interactively, just edit the data source using Analysis
Manager.

If you need it programmatically, write a VB script which uses DSO to edit
the data source.
A sample VB script that use DSO, look at the AS Operations Guide, here
http://www.microsoft.com/technet/pro.../anservog.mspx
(Appendix H, I and J)
It doesn't have one that edits the data source, but it does other DSO
operations so you can use it to jumpstart your work.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Klaus Wiesel" <klaus.wiesel (AT) infor (DOT) com> wrote

Hi

as described, I have a problem just editing the datasource - it is
somewhere inside because I cannot process a cube after editing it - the
old datasource is still in there...

Regards
Klaus

Dave Wickert [MSFT] wrote: