Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package
- 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