A customer asked me if it was possible to build and deploy SSIS packages using VSTS. Without thinking, I answered, “Of course you can (I had no clue if you could or not but Any Language, Any Platform right?)! And Premier Developers (they had a Premier contract with Microsoft) can tell you exactly how to do it”. Premier did not disappoint. Roy Lofthus immediately provided the following solution. I’m blogging this so if I ever need this again, I can find it quickly
The command line arguments for SSIS:
“$(Build.SourcesDirectory)\SSDTDemo1\SSDTDemo1.sln” /rebuild $(BuildConfiguration) /project “$(Build.SourcesDirectory)\SSDTDemo1\Integration Services Project1\Integration Services Project1.dtproj”
To “compile” SSRS you also use devenv.exe with the following arguments:
“$(Build.SourcesDirectory)\SSDTDemo1\SSDTDemo1.sln” /rebuild $(BuildConfiguration) /project “$(Build.SourcesDirectory)\SSDTDemo1\Report Project1\Report Project1.rptproj”
You can then create a release definition and use the command-line tools (i.e. Microsoft.AnalysisServices.Deployment.exe/dtutil.exe) to deploy SSAS/SSIS with the artifacts created in the build definition. Make sure SSDT is installed on the build agent. You can also pretty this up by making custom build/release tasks for building and release SSIS and SSRS packages which can then be shared by everyone.