Hi @wajika ,
Welcome to Microsoft Q&A!
How did you install the SSDT package?
Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation.
You can install SQL Server Data Tools through installing the Data storage and processing workload.
After installing successfully, you can launch VS and create project by searching SQL Server Database Project.
For Analysis Services, Integration Services, or Reporting Services projects, it is installed through the SSDT standalone installer.
You can refer to the link:
https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-visual-studio-2017
Sincerely,
Anna
*
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.