SSIS 包的 TFS CI 问题

发布于 2024-12-16 17:37:34 字数 988 浏览 0 评论 0原文

构建于 2011 年 11 月 16 日上午 9:24:11 开始。节点 1 上的项目“C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln”（默认目标）。验证解决方案配置：构建解决方案配置“开发|默认”。 MSBUILD：警告 MSB4078：MSBuild 不支持项目文件“blah\blah.dtproj”，无法生成。 [C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln] 完成构建项目“C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln”（默认目标）。
构建成功。
“C:\Builds\1\NetTellerMigration\blahBuild\Sources\blah.sln”（默认目标）(1) -> （blah_b 目标）-> MSBUILD：警告 MSB4078：MSBuild 不支持项目文件“blah\blah.dtproj”，无法生成。 [C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln]

1 Warning(s)
0 Error(s)

已用时间 00:00:00.42

我目前已经使用 SqlExpress 安装了 tfs2010，并且尝试“不成功”地针对 SSIS 包实施持续集成。我的目标是创建由代码签入触发的构建。我有一个 doso 的构建定义，但显示了上面显示的警告，并且没有将“.dtsx”文件复制到构建目录？

我相信它与针对 .net 框架 v4 的构建代理有关，但我可能是错的。无论如何，任何曾经遇到过这个问题的人都将不胜感激。

原文

Build started 16/11/2011 9:24:11 AM.
Project "C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln" on node 1 (default targets).
ValidateSolutionConfiguration:
Building solution configuration "Development|Default".
MSBUILD : warning MSB4078: The project file "blah\blah.dtproj" is not supported by MSBuild and cannot be built. [C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln]
Done Building Project "C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln" (default targets).
Build succeeded.
"C:\Builds\1\NetTellerMigration\blahBuild\Sources\blah.sln" (default target) (1) ->
(blah_b target) ->
MSBUILD : warning MSB4078: The project file "blah\blah.dtproj" is not supported by MSBuild and cannot be built. [C:\Builds\1\NetTellerMigration\NetTellerMigrationBuild\Sources\blah.sln]

1 Warning(s)
0 Error(s)

Time Elapsed 00:00:00.42

I currently have tfs2010 installed with SqlExpress and im trying 'unsucessfully' to implement continuous-integration against a SSIS package. My aim is to create a build triggered by a code checkin. I have a build definition to doso but the warning shown above is displayed and no '.dtsx' files are copied to the build directory?

I believe its something to do with the build agent targeting v4 of the .net framework but I could be wrong. Anyway, any help would be much appreciated from anyone who has experience this problem before.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

隐诗 2024-12-23 17:37:34

MSBuild 无法生成 SSIS 项目 (.dtproj)，因为这些项目的格式是 VS2010 之前的版本。这里最好的做法是让 MSBuild shell 进入 SSIS 项目。您可以创建一个空的 C# 项目来执行此操作。然后，在文本编辑器中打开新项目的 .csproj 文件，并将 BeforeBuild 目标设置为以下内容：

<Target Name="BeforeBuild">
  <!-- Build the analysis SSIS project -->
  <Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\@InstallDir)\devenv.exe" blah\blah.dtproj /Build" />
</Target>

调整项目的 blah/blah.dtproj 路径。这将运行 VS2008 版本的 devenv 来构建 SSIS 项目。

下面是整个 .csproj 文件的示例：

<?xml version="1.0" encoding="utf-8"?>
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0" DefaultTargets="Build">
   <PropertyGroup>
      <OutputPath>Bin</OutputPath>
   </PropertyGroup>
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <Target Name="BeforeBuild">
      <!-- Build the analysis SSIS project -->
      <Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\@InstallDir)\devenv.exe" blah\blah.dtproj /Build" />
  </Target>
</Project>

MSBuild can't build SSIS projects (.dtproj) because the format of these projects is pre-VS2010. The best thing to do here is to have MSBuild shell out to the SSIS project. You can create an empty C# project to do this. Then, open the .csproj file for the new project in a text editor and set the BeforeBuild target to the following:

<Target Name="BeforeBuild">
  <!-- Build the analysis SSIS project -->
  <Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\@InstallDir)\devenv.exe" blah\blah.dtproj /Build" />
</Target>

Adjust the blah/blah.dtproj path for your project. This will run the VS2008 version of devenv to build the SSIS project.

Below is a sample of what the whole .csproj file might look like:

<?xml version="1.0" encoding="utf-8"?>
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0" DefaultTargets="Build">
   <PropertyGroup>
      <OutputPath>Bin</OutputPath>
   </PropertyGroup>
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <Target Name="BeforeBuild">
      <!-- Build the analysis SSIS project -->
      <Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\@InstallDir)\devenv.exe" blah\blah.dtproj /Build" />
  </Target>
</Project>

回复收藏 0 原文

八巷 2024-12-23 17:37:34

我必须稍微调整我的目标才能使其正常工作：

<Target Name="BeforeBuild">
<!-- Build the analysis SSIS project -->
<Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\9.0\@InstallDir)devenv.exe" "$(SolutionPath)" /Build "Release|Any CPU" /project projectFileName.dtproj" />
</Target>

I had to slightly tweek my target to get it working:

<Target Name="BeforeBuild">
<!-- Build the analysis SSIS project -->
<Exec Command=""$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\9.0\@InstallDir)devenv.exe" "$(SolutionPath)" /Build "Release|Any CPU" /project projectFileName.dtproj" />
</Target>

回复收藏 0 原文

~没有更多了~