To show the possibilities with continuous integration with SQL Server development, I decided to spin up a virtual machine with Visual Studio 2013, Team Foundation Server 2013, and SQL Server 2014. While setting it up, I ran into an error that I thought I’d share here.

With Visual Studio 2013 you can no longer download SQL Server Data Tool separately, as SQL Server tooling is included. You will need to use either one paid versions of Visual Studio or one of the free express editions.

C:Builds3MyProjectAdventureWorks Test Server BuildSourcesMainAdventureWorksAdventureWorksAdventureWorks.sqlproj (63): The imported project "C:Program Files (x86)MSBuildMicrosoftVisualStudiov11.0SSDT 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.

I am facing the below problem e:Builds1ONEOne_database_publishbinOneEHR_OrderView.publish.sql: The source file ‘e:Builds1ONEOne_database_publishsrcONEDatabasesOneEHR_OrderViewOneEHR.publish.xml’ could not be opened (‘The system cannot find the specified file. ‘).

Hey David,
Great article I am facing similar kind of problem but got stuck somewhere , I am working on Schedule Builds I followed complete steps mentioned in that Jamie Blog I am facing same issue that you mentioned in the article ” The imported project “C:Program Files(x86)MSBuildMicrosoftVisualStudiov11.0SSDTMicrosoft.Data.Tools.Schema.SqlTasks.targets” was not found. Confirm that the path in the declaration is correct, and that the file exists on disk.”
I am working on Visual Studio 2013 and SQL Server R2 can you let me know where I am going wrong !! This means a lot to me !!! Waiting for your response !! Thank you