Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
- Get ASCMD for right version
-Create a file with XMLA / MDX Command and give extension as xmla/mdx
-Create one batch file with command with text as d:\asjob\ascmd -S karan2k8-64\sql2005 -i d:\asjob\backup.xmla
In my instance- ASCMD is located in D Drive ASJob folder that’s why I had given it in Path same for AS Xmla file is located in same folder. In order to remove confusion at the time of ASCMD execution better to keep batch file, ascmd.exe and xmla / mdx files in same folder.
Read more about it at https://blogs.msdn.com/b/karang/archive/2010/07/17/running-as-command-xmla-mdx-as-a-batch-job-using-ssis-package.aspx