none
Can't use ASCMD in Command line RRS feed

  • Question

  • Hey everyone.

    I'm working with sql server management studio 2012.

    I want to use ASCMD command to run XMLA scripts to process Cube or dimensions.

    Any help please?

    Friday, November 30, 2018 11:21 AM

All replies

  • Hey everyone.

    I'm working with sql server management studio 2012.

    I want to use ASCMD command to run XMLA scripts to process Cube or dimensions.

    Any help please?


    • Edited by Ghlila omar Friday, November 30, 2018 10:58 AM
    • Merged by Olaf HelperMVP Friday, November 30, 2018 12:18 PM Same question from same OP
    Friday, November 30, 2018 10:39 AM
  • Why can't you use ASCMD? Is there an error message that is preventing you or do you want general info on how to use it?
    Friday, November 30, 2018 3:25 PM
  • I found it :

    C:PS> Invoke-ASCmd -InputFile:"C:MyFolderDiscoverConnections.xmla"

    Friday, November 30, 2018 3:36 PM
  • Hi Ghlila omar,

    Thanks for sharing the solution with us.

    In addition, you can also have a try following command to run the xmla script.

    ascmd -S -i c:\xxx.xmla

    Reference: Using ASCMD to run command line scripts for SQL Server Analysis Services

    Regards,

    Pirlo Zhang 


    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    Monday, December 3, 2018 2:03 AM