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

Written by Karan Gulati on 03 October 2010. Posted in Management

- Get ASCMD for right version

-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"