I have converted my cubes to Yukon, and have generated an xmla script. How
can I exeute this script from the command line?

Thanks,
--
Jason

Within an IS package there is a new task called Execute Analysis Services
DDL. A simple package with just one task it will do it. The task can take
its script from either a file or a variable. Then you launch the package via
dtexec overriding the location of the xmla filename for the task to execute.
--
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

Thanks, for the info. I am learning to use the DTEXEC. I cannot figure out
how I can pass the file name and location into the package (DTSX) for my AS
XML file. Any help or direction you can pass me in this forum, or web link
that may provide a little more information? I was hoping I could set it up
so I could pass it directly from the command line.

Thanks,
--
Jason


"Dave Wickert [MSFT]" wrote:

From a dos box, do a DTEXEC /?
You will see that there is a switch to supply a config file.
The config file will have an override for a property of the DDL task file
name.
Or you could put the file name into a variable and use an expression.
Or you could put the XMLA script text in the config file to be loaded into a
variable and then have the DDL task take the script from the variable.
--
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

Thanks for the help. I will try to do this. Sounds like the config file is
the way to go, now to figure out how to create one. I have been watching
SSIS webcasts to figure out how to do some of this in SS 2005, but haven't
found this yet.

Thanks,
--
Jason


"Dave Wickert [MSFT]" wrote: