CSI TFS issue with SSIS

Question

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

Assembly completed successfully.

"C: \ Builds \ 1 \ NetTellerMigration \ blahBuild \ Sources \ blah.sln" (default target) (1) → (target blah_b) → MSBUILD: warning MSB4078: project file "blah \ blah.dtproj" is not supported by MSBuild and cannot be created. [C: \ Builds \ 1 \\ netTellerMigration NetTellerMigrationBuild \ Sources \ blah.sln]

1 Warning(s) 0 Error(s) 

Elapsed time 00: 00: 00.42

I currently have tfs2010 installed with SqlExpress, and I'm trying to "unacceptably" implement continuous integration with the SSIS package. My goal is to create an assembly called code verification. I have a build definition for doso, but the warning shown above is displayed and no .dtsx files are being copied to the build directory?

I believe this has something to do with targeting the v4 build agent in the .NET Framework, but I could be wrong. In any case, any help would be greatly appreciated by anyone who already has this problem.

Answer 1

MSBuild cannot create SSIS projects (.dtproj) because the format of these projects is before VS2010. Your best bet here is to get MSBuild to exit the SSIS project. You can create an empty C # project for this. Then open the .csproj file for the new project in a text editor and set the BeforeBuild parameter to the following:

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

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

The following is an example of what the entire .csproj file looks 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="&quot;$(Registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\@InstallDir)\devenv.exe&quot; blah\blah.dtproj /Build" /> </Target> </Project> 

Answer 2

I had to slightly tweak my goal to make it work:

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