Share via

The [VS2017PATH] points to the SSMS 21 Preview directory instead of the Visual Studio 2022 directory. How can I modify it to correctly reference the VS2022 directory when searching for the SSDT folder in the wxs file using DirectorySearch?

Chirag Gaonkar 5 Reputation points
Feb 11, 2025, 6:48 PM

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:

PowerShell
<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:

  1. 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?
  2. 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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,901 Reputation points
    Feb 12, 2025, 2:50 AM

    Hi @Chirag Gaonkar

    SSMS21 is currently in its preview phase and has not yet reached its official release.

    Please note that features and specifications are still subject to change during this development stage. We recommend waiting for the finalized version before making implementation decisions or production deployments.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.