Re: Analysis Services Command line

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

>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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0476829C-7921-4785-B8C6-89E49D773DAD@xxxxxxxxxxxxxxxx
> 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:
>
>> 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@xxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:949FB9BB-B01B-4380-BF0E-706419D9189A@xxxxxxxxxxxxxxxx
>> >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
>>
>>
>>


.

Relevant Pages

  • Re: Analysis Services Command line
    ... > You will see that there is a switch to supply a config file. ... > variable and then have the DDL task take the script from the variable. ... >>> Within an IS package there is a new task called Execute Analysis Services ...
    (microsoft.public.sqlserver.olap)
  • Re: Upgrading SVR4 packages and config files
    ... unwanted_new_config and install your personal favorites. ... I was asking what the package creators do to automate the process, ... Today I packaged the thing which delivers config file in .etc and then ... postinstall script copies it to etc. ...
    (comp.unix.solaris)
  • Re: Analysis Services Command line
    ... I am learning to use the DTEXEC. ... how I can pass the file name and location into the package for my AS ... > dtexec overriding the location of the xmla filename for the task to execute. ... >>I have converted my cubes to Yukon, and have generated an xmla script. ...
    (microsoft.public.sqlserver.olap)
  • Re: Why not XML based configurationfiles?
    ... >>I still have yet to see your working shell script that can parse XML ... Sure one might need to parse a config file in a shell script "for ... the XML file directly or make heavy use of cfg-tool. ...
    (comp.os.linux.misc)
  • Re: Whereis Kernel? & Why Debian "KDE" freezing?
    ... > There is no config file in. ... Thats not a Script, thats the kernel. ... your KDE is unstable. ...
    (alt.linux)