How to install SSIS in Visual Studio 2019? SQL Server Integration Services

Step by step guide on how to install SQL Server Integration Services Projects in Visual Studio 2019.

Microsoft BI tutorial on how to install SSIS in Visual Studio 2019. One prerequisite to this tutorial is to have Visual Studio 2019 already installed on your computer, running for example on the Windows 10 Pro operating system. With Visual Studio 2017, SSIS, SSAS and SSRS projects were available with the installation of SSDT (SQL Server Data Tools).

But since Visual Studio 2019 now the modules are downloadable and installable as independent extensions, without SSDT (SQL Server Data Tools). SSIS tools and services are widely used as a part of MS Decision Support Systems.

Step-by-step SSIS installation tutorial in video

Install SSIS in Visual Studio 2019 in 3 steps

To install SSIS and create Integration Services projects in Visual Studio 2019, follow these three simple steps. Please note that the screenshots are in English because they were taken with an English version of Visual Studio.

Step 1: Download SQL Server Integration Services Projects extension

To download the SSIS extension, follow these steps:

  1. Open the Manage Extensions menu in Visual Studio 2019.
  2. Then search for the Integration Services extension and click Download.

Note that you can also download the extension directly from the Visual Studio Marketplace official website.

Download the SQL Server Integration Services Projects extension from Visual Studio 2019
Download the SQL Server Integration Services Projects extension from Visual Studio 2019

Step 2: Install the SSIS extension in Visual Studio 2019

The installation executable file named Microsoft.DataTools.IntegrationServices.exe is downloaded via the default browser on your Windows system. To avoid installation errors, make sure to use these tips:

  1. Close all Visual Studio 2019 windows.
  2. Also close any other SSIS installation windows.
  3. And if necessary, stop the Windows process called PerfWatson2. To do this, open the Task Manager (CTRL + ALT + DELETE), go to the Details tab, right-click and select End Task.
Install SSIS in Visual Studio 2019 (SQL Server Integration Services Projects)
Install SSIS in Visual Studio 2019 (SQL Server Integration Services Projects)

Step 3: Create an SSIS project with Visual Studio

Finally, create a new SSIS project to check that the installation is correct and functional. To do this, first restart your computer or laptop, then open VS2019, and select create a new project, then search for Integration Services and select Integration Services Project and submit.

Create an SSIS project with Visual Studio 2019
Create an SSIS project with Visual Studio 2019

This short SSIS tutorial explains how to get started with the Microsoft ETL. And the very first step is to install the extension in Visual Studio and create a first Integration Services project. Read this other tutorial on how to easily import XML documents into a database using SSIS.

2 Comments

  1. Could not find PerfWatson2 in the details tab of Task Manager, but I did eventually find it in another tab and stopped it. Everything else went fine with the setup and I now have my first SSIS Project.

Leave a Reply

Your email address will not be published.


*