Issue with SSDT Folder Search Path in SSMS 21 Preview
I’m encountering an issue with the search path for the SQL Server Data Tools (SSDT) folder when using SQL Server Management Studio (SSMS) 21 Preview.
Below is the wxs code I’m using for the search path:
<Property Id="VS2017_SSDTPATH">
<DirectorySearch Id="GET_VS2017_SSDTPATH" Path="[VS2017PATH]">
<DirectorySearch Id="GET_VS2017_SSDTPATH_MSBuild" Path="MsBuild">
<DirectorySearch Id="GET_VS2017_SSDTPATH_Microsoft" Path="Microsoft">
<DirectorySearch Id="GET_VS2017_SSDTPATH_VisualStudio" Path="VisualStudio">
<DirectorySearch Id="GET_VS2017_SSDTPATH_SSDT" Path="SSDT" Depth="2"/>
</DirectorySearch>
</DirectorySearch>
</DirectorySearch>
</DirectorySearch>
</Property>
After installing SSMS 21 Preview, I noticed that the [VS2017PATH] is pointing to "C:\Program Files\Microsoft SQL Server Management Studio 21\Preview" instead of the expected path: "C:\Program Files\Microsoft Visual Studio\2022\Professional".
This causes the error: “No installation of SQL Server Data Tools (SSDT) was found for the latest version of Visual Studio.”
The issue is resolved if the [VS2017PATH] points to the SSDT folder located at "C:\Program Files\Microsoft SQL Server Management Studio 21\Preview\MSBuild\Microsoft\VisualStudio\v17.0". However, this folder isn't included by default, and I had to manually add the SSDT folder to this location.
Questions:
- Will the SSDT folder be added to "C:\Program Files\Microsoft SQL Server Management Studio 21\Preview\MSBuild\Microsoft\VisualStudio\v17.0" in future versions, of SSMS 21 Preview?
- Where exactly is the [VS2017PATH] variable defined, and how does it change dynamically? Additionally, how can I configure it to point to the correct path: "C:\Program Files\Microsoft Visual Studio\2022\Professional\MSBuild\Microsoft\VisualStudio\v17.0"?
Any insights or solutions would be greatly appreciated!