在VSTS托管构建代理中构建SSIS .dtproj [英] Building SSIS .dtproj inside a VSTS Hosted Build Agent

问题描述

我正在尝试构建一个SSIS 2016项目，该项目已在VSTS构建中使用项目部署模型进行了配置，目的是将.ispac文件部署到Azure中托管的SQL Server VM上.

I'm trying to build a SSIS 2016 project, that's been configured with the Project Deployment model in a VSTS build with the intent to deploy the .ispac file onto a SQL Server VM hosted in Azure.

使用MSBuild生成项目文件会返回以下错误:

Using MSBuild to build the project file returns the following error:

The default XML namespace of the project must be the MSBuild XML namespace. 
If the project is authored in the MSBuild 2003 format, please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to the  element. 
If the project has been authored in the old 1.0 or 1.2 format, please convert it to MSBuild 2003 format.

我在这里找到了描述相同问题的博客帖子

I found a blog post here describing the same issue

https://speaksql.wordpress.com/2013/06/07/a-journey-to-db-deployment-automaton-ssis-build-using-msbuild/

但是，该解决方案取决于将SQL Server数据工具安装到构建代理中.

However, the solution depends on installed SQL Server Data Tools into a build agent.

有没有一种方法可以使用VSTS托管代理，而不必创建安装了SSDT的本地代理?

Is there a method where I can use a VSTS Hosted agent, and not have to create an on-premises agent with SSDT installed?

推荐答案

刚刚发布了VSTS/TFS的新扩展

Just released new Extension for VSTS/TFS

https://github.com/ToxicGlobe/VSTS-SSIS-Extension

它构建了Visual Studio项目，其中包含项目部署文件(.ispac)的程序包和参数

It build Visual Studio project, containing packages and parameters to a project deployment file (.ispac)

https://marketplace.visualstudio.com/items?itemName=TG .VSTS-SSIS

这篇关于在VSTS托管构建代理中构建SSIS .dtproj的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！