Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package

  – 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 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…

6