Is there any way to assign a data source depending on what deployment
configuration is being used?

I find myself just changing it manually, would like to do it automatically
somehow.

TIA,

Jesse.

XMLA scripting. Using SSMS, right click on your data source, then script out
an ALTER XMLA script. It is a text file which can be modified to change
server and database names.

To execute the script you can use any one of 4 options:
1) SSMS allows you to execute it interactively
2) SQL Agent jobs had a new "step" type which is an XMLA script -- thus a
SQL Agent job could execute it
3) SSIS packages have an "Execute Analysis Services DDL task" which executes
an XMLA script
4) Coming in about April or May (WR2 Samples MSI) will be a new sample
utility called ascmd which is a command-line utility for executing XMLA
scripts. If you would like to be included in the beta, send me an email and
I'll forward it to the right people.

Hope that helps.
--
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.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote