I just update my visual studio and I am not able to open my sqlproj included into my sln.
The issue is the following one :
error : The imported project "C:\agent\Microsoft.Data.Tools.Msbuild\lib\net40\Microsoft.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 do not have the C:\agent folder present in my HD.
I think something changed my variables used by the sqlproj file.
<Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
How can I reset thoses variables : $(MSBuildExtensionsPath), $(MSBuildToolsVersion)
I strongly think this is related to my MSBuildToolsVersion variable.
I tried to repaire my vs2017 community installation. Still not working :/
Any idea?
Nothing related to those variable.
I was at the wrong place in the sqlproj file.
I should look into this:
<Import Condition="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
I just unset this variable SQLDBExtensionsRefPath from my windows environement.
Because it was set, it will take the first parth instead of the one related to my Visual studio.