Search code examples
sql-servermsbuildtfsbuildtfs-2015sql-server-data-tools

TFS vNext build Error SQL72027 File Does Not Exists For SQL Database Project

Thanks in advance for reading this.

Unable to create a vNext Build for a composite SQL Server database project (that has a database reference). The Build is to push code from our on-premise TFS to a Dev database.

We're using VS 2015 Update 3 to create the SQL Server database project and we've TFS 2015 update 2.

In the SQL Server database project let's say you added a database reference called MyReference.dacpac (and the referenced dacpac sits in another TFS folder in the same Team Project):

How source control in TFS looks like:

-- MyTeam
 ---- DEV
  ------ Database
  ------ Common (where referenced dacpac is located)
  ------ BuildTest.Database

The vNext build error is:

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v14.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(550,5): Error SQL72027: File "E:\Root\TFS2015\Dev\Database\Common\MyReference.dacpac" does not exist.

Here's part of the build definition:

enter image description here

Would appreciate any help!

Solution

  • To narrow down the issue, please try the items below:

    1. Check whether the MyReference.dacpac under path E:\Root\TFS2015\Dev\Database\Common on your build agent machine

    2. Log on to your build agent machine, and run the project manually with MSBuild command line, to check the result.

    3. Check how do you reference MyReference.dacpac locally, and check the source directory on your build agent machine to see whether the structure of the project is the same as local.