How to build and deploy SSRS project through VSTS?

问题:

I created simple SSRS project in VS2015. I want to build and deploy the SSRS project using VSTS by creating the build definition and release definition steps.

Is there any third party VSTS extension available or for SSRS build and SSRS Deploy not same like as SSIS Build and SSIS Deploy tasks?

Can you please tell me how to build and deploy SSRS project through VSTS?

回答1:

There is SQL Server Reporting Services Deployment extension.

Simple sample tasks:

1. Command Line (Tool: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe; Arguments: "$(build.sourcesdirectory)/ReportDemo.sln" /build "$(BuildConfiguration)"; Working folder: $(build.sourcesdirectory))
2. SQL Server Reports Deployment (Report files: $(System.DefaultWorkingDirectory)/**/bin/$(BuildConfiguration)/*.rdl; Upload path:/BuildTest; Webservice URL: http://XXX/ReportServer/ReportService2010.asmx?wsdl)