Extend SSAS for MSBuild like you can for SSIS

729 Views Asked by At

Hey so I figured out how to do automated deployment in Hosted Builds for VSTS for SSIS. I used the article in this link (https://speaksql.wordpress.com/2013/06/07/a-journey-to-db-deployment-automaton-ssis-build-using-msbuild/) with a lot of research and trial and error to make it work for modern settings aka VS17, SQL16, and DotNet 4.6.1.

Anyways I was to do the exact same kind of process now for SSAS. I do not want to use Devenv.exe for this task. Reason being Hosted VSTS builds do not have licenses associated with their Visual Studio thus forcing the use of MSBuild instead. Looking for articles and guides that do not use Devenv.exe.

Ideal situation would be Msbuild extension like I did for SSIS that I can point it at the solution or the .dwproj file.

Thanks!

1

There are 1 best solutions below

2
starian chen-MSFT On

Building SSAS project through MSBuild directly is not supported, check this user voice: Support SSAS / SSIS / SSRS in Msbuild.

You can setup a private build agent: Deploy an agent on Windows, then do build/release by using this agent.