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 the Step 8 and then follow the steps in this article.

How to install the Older Versions of Visual Studio?

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.

Articles related to Visual Studio that you might like.

How to Install Visual Studio 2022?

How to install the Older Versions of Visual Studio?

How to Install Visual Studio Code?

Visual Studio and the .NET Framework for Dynamics 365 CRM Online V9.X

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.