构建“*.DTPROJ"- 带有 devenv.exe 的构建服务器上的 SSIS (Visual Studio 2012) [英] Build "*.DTPROJ" - SSIS on the build server with devenv.exe (Visual Studio 2012)

问题描述

我正在尝试在构建服务器上使用 Visual Studio 2012 构建 SSIS 项目 (*.dtproj).

I'm trying to build a SSIS project (*.dtproj) with Visual Studio 2012 on the build server.

据我所知，不支持直接使用 MSBuild 构建此类项目.

As far as I know there's no support to build this kind of project directly using MSBuild.

但是我的想法是，如果我可以在本地使用 Visual Studio 2012 IDE 构建它，我将能够使用 Visual Studio 命令行(调用 devenv.exe/devenv.com)直接从命令行构建它构建服务器

However my thinking is that if I can build it using the Visual Studio 2012 IDE locally, I would be able to build it using the Visual Studio command line (calling devenv.exe/devenv.com) directly from a command line on the build server

但是我已经尝试了很多组合，却没有找到任何有效的组合

But I have tried so many combinations and I have not been able to find anything that works

我一直收到以下错误:

Microsoft (R) Microsoft Visual Studio 2012 Version 11.0.60315.1.
Copyright (C) Microsoft Corp. All rights reserved.
Error: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

这是我使用的命令行:

."C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.com" .\Datawarehouse_ETL.sln /ReBuild Development /Project .\Datawarehouse_ETL\Datawarehouse_ETL.dtproj /ProjectConfig Development /Log .\output.log /out .\output.log

我想我用来调用 devenv.com

但根据 MSDN

/Build (devenv.exe) 此开关执行与集成开发环境 (IDE) 中的 Build Solution 菜单命令相同的功能.用双引号将包含空格的字符串括起来.构建的摘要信息(包括错误)可以显示在命令窗口中，或显示在使用/out 开关指定的任何日志文件中.此命令仅构建自上次构建以来已更改的项目.要在解决方案中构建所有项目，请使用/Rebuild (devenv.exe).

/Build (devenv.exe) This switch performs the same function as the Build Solution menu command within the integrated development environment (IDE). Enclose strings that include spaces in double quotation marks. Summary information for builds, including errors, can be displayed in the Command window, or in any log file specified with the /out switch. This command only builds projects that have changed since the last build. To build all projects in a solution, use /Rebuild (devenv.exe).

我在几个论坛上发现了这个问题，但那里提出的解决方法都没有对我有用.

I have found several forums with this question but none of the workarounds proposed there have worked for me.

顺便说一句根据这篇文章，devenv.com 只是在 devenv.exe 之上的一个包装器，用作命令行

BTW according to this post, devenv.com is just a wrapper on top of devenv.exe to be used as a command line

我即将放弃，只是手动/本地构建解决方案并检查构建后生成的 *.ispac 文件，然后编写一个 PowerShell 脚本来部署该 =(((((

I'm about to give up and just build the solution manually/locally and check in the *.ispac file generated after building and just write a PowerShell script to deploy that =(((((

推荐答案

SSDT-BI 的初始版本中存在错误已在后续版本中修复http://www.microsoft.com/en-us/download/details.aspx?id=36843

There was bug in initial release of SSDT-BI which was fixed in the following release http://www.microsoft.com/en-us/download/details.aspx?id=36843

在此处查找 Microsoft 反馈站点对上述问题的响应http://connect.microsoft.com/SQLServer/feedback/details/781872/fail-to-build-ssis-ssas-projects-via-vs2012-command-line-devenv-exe-with-ssdt-bi-tool-installed

Find here response from Microsoft Feedback site for above probelm http://connect.microsoft.com/SQLServer/feedback/details/781872/fail-to-build-ssis-ssas-projects-via-vs2012-command-line-devenv-exe-with-ssdt-bi-tool-installed

这篇关于构建“*.DTPROJ"- 带有 devenv.exe 的构建服务器上的 SSIS (Visual Studio 2012)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！