I have about 10 cubes I have developed and I am trying to deliver them to
customers as painlessly as possible I can for them. I can write a script to
restore the .cab file using the msmdarch.exe from the command line, but the
problem is, I still have to manually change the data source via Analysis
Manager. Is there anyway to automate this process assuming I know the data
source connection info? Then once I get that, is there an easier way to
reprocess cubes from the command line than creating a DTS package to
reprocess them, and execute the package using DTSrun.exe from the command
line?
--
Jason

Yes, you can easily do this by writing a VBScript.
If you look in the AS Operations Guide and the AS Performance Guide we have
several VB Scripts which walk DSO (the API used to administer and control
Analysis Services). See this link:
http://www.microsoft.com/sql/evaluat...bianalysis.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"JasonDWilson" <JasonDWilson (AT) discussions (DOT) microsoft.com> wrote