How To Install SQL Server Data Tools In Visual Studio 2019

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.

• How To Install The Older Versions Of Visual Studio (c-sharpcorner.com)

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.

Step 5 

Once it is downloaded, Go to Downloads and Double click on Microsoft.DataTools.IntegrationServices to start the installation process.

Step 6

Choose your required Language and Click on OK.

Step 7

Click on Next.

Step 8 

Click on Install.

Installation is in progress.

Step 9 

Setup is Completed. Click on Close.

Note: Restart the PC.

Step 10

Open Visual Studio 2019. Click on File -> New -> Project.

Step 11

Search for Integration Services Project.

Step 12

Click on Integration Services Project and Click on Next.

Step 13 

Provide the Project name, Location and Solution name and Click on Create.

SSIS Project will be opened.

Hope you have followed all the steps and successfully installed SQL Server Data Tools in Visual Studio 2019.

Like and share your valuable feedback on this article.