SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports.
With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Follow the below steps to install the SQL Server Data Tools in Visual Studio 2019.
Pre-Requisite
Click on the below article link to Install Visual Studio 2019 with the workload Data storage and processing as mentioned in Step 8 and then follow the steps in this article.
Step 1
Launch Visual Studio 2019.
Step 2
Click on Continue without code.
Visual Studio IDE will be opened.
Step 3
Click on Extensions -> Manage Extensions.
Step 4
Search for SQL Server Integration Services Projects and Click on Download.
Microsoft.DataTools.IntegrationServices.exe will be downloaded.
Note: Close the Visual Studio 2019.
Join the conversation! Your thoughts help the community grow.