Where can I download a ascmd.exe?

Question

Hello, I need to execute MDX query from command line (MS AS 2005). I have heard, that there is a program named ascmd, which can do this. Unfortunately, when I went to codeplex page I found that page supposed to deliver an ascmd doesn't work. Please help if you know any other page, where I can download ascmd or any other program executing MDX in command line. Thanks for reply!

Answer 1

You will get with SP2 samples.

You can download and install it separately from http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Answer 2

ascmd.exe is included in this MS-SQL Server samples download. This is a different page than the one you probably went to originally, it has moved. Just click on the SqlServerSamples.msi link.

Answer 3

Thanks. I've just installed Samples on my desktop. Now -- which file I should run to have a ascmd? I don't have any executables, only .sln, .cs, .csproj.

Answer 4

With MS AS 2005 you should have under "sample_inst\Analysis Services\Administrator\ascmd\CS".

where sample_inst is the folder where you have installed the samples

Typcally:

"C:\Program Files\Microsoft SQL Server\90\Samples"