2
votes

I've created a Team City project that will build SSIS v2008 project, utilising MSBuild to create the SSIS pacakges. I'm able to run to build SSIS project from the command line:

      C:\TeamCity\buildAgent\work\3c40e9b3942c4213\Source\ETL.Scheduler\ETL.Schedule
      msbuild Build.xml /t:Default /verbosity:diaG

However when I attempt to run from Team City, will fail and state unable to find project file at within the TeamCity build directory.

After following advice given in Compiling SSIS Projects with Team City, I was able to build SSIS solution in Team City. As stated unable to run from within Team City, but can be done from commandline.

Below is screenshot of the buildstep.

enter image description here

Can anyone assist with this.

2
whats the build log say? click on dropdown next to 'Failed build'wal
Step 2/3: Build (MSBuild) (1s) C:\TeamCity\buildAgent\plugins\dotnetPlugin\bin\JetBrains.BuildServer.MsBuildBootstrap.exe /workdir:C:\TeamCity\buildAgent\work\3c40e9b3942c4213 /msbuildPath:C:\Windows\Microsoft.NET\Framework64\v3.5\MSBuild.exe [09:45:43][Step 2/3] in directory: C:\TeamCity\buildAgent\work\3c40e9b3942c4213 [09:45:45][Step 2/3] Failed to start MSBuild.exe. Failed to find project file at path: C:\TeamCity\buildAgent\work\3c40e9b3942c4213\Source\ETL.Scheduler\ETL.Scheduler [09:45:45][Step 2/3] Process exited with code -42Nobody
go to that directory then :\TeamCity\buildAgent\work\3c40e9b3942c4213\Source\ETL.Scheduler\ETL.Scheduler - is your stuff there? if not, then its not being checked out correctly (or at all) in a previous step. you probably have the path wrong if it is being checked out (eg perhaps without `Source` (just a guess))wal
Yes, source directories are created within Team CityNobody
have you actually specified the name of the msbuild file? that looks like a directory name, not a filename.wal

2 Answers

3
votes

The Build File Path is relative to the checkout directory. Try just using Source\ETL.Scheduler\ETL..... in that field.

1
votes

After consultation with team city expert and a combination of trial and error, specify directly the build file path - Source/ETL.Scheduler/ETL.Scheduler/Build.xml