- Get ASCMD for right version

2008

2005

 

-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 http://blogs.msdn.com/b/karang/archive/2010/07/17/running-as-command-xmla-mdx-as-a-batch-job-using-ssis-package.aspx