Tfs build fails with Database Projects

Posted on One min read

If you have a TFS Builds that fails with an error like this one, even if you have installed Visual Studio 2013 on your build server.

The imported project “C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets” was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk

The reason could be that you miss Sql Server Data Tools, you only need to download them in all servers with Build Agents and install it. Now the build should runs without problems.

Gian Maria.