How to install the SQL Server Integration Services (SSIS) projects in Visual Studio 2019?
This is a Microsoft tutorial on installing the SQL Server Integration Services Projects extension on Visual Studio 2019. We assume that Visual Studio 2019 is already installed on your computer, which is using for example the Windows 10 operating system.
With Visual Studio 2017, SSIS, SSAS and SSRS projects were available with the installation of SSDT (SQL Server Data Tools). This has changed with Visual Studio 2019. Integration Services tools and services are widely in Decision Support System projects.
The SSIS tutorial is also available as a step-by-step video, with a Visual Studio 2019 version.
Install SSIS in Visual Studio 2019 in three steps
Time required: 15 minutes.
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.
1. Download the SQL Server Integration Services Projects extension
Download the SQL Server Integration Services Projects extension from the Manage Extensions menu in Visual Studio 2019. Then search for the Integration Services extension and click Download. You can also download the extension directly from this link: SSIS Projects from marketplace.visualstudio.com
2. Install the SSIS projects extension on VS 2019
The installation executable file named Microsoft.DataTools.IntegrationServices.exe is downloaded via the default browser. To avoid installation errors :
- Close all Visual Studio 2019 windows.
- Also close the other SSIS installation windows.
- And finally 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.
3. Create an SSIS project with Visual Studio 2019
Finally, create a new SSIS project to check that the installation is correct and functional. To do this, open VS2019, and select create a new project, then search for Integration Services and select Integration Services Project and submit.
This short tutorial on SSIS explains how to get started with the Microsoft ETL. That is, install the extension in Visual Studio and create a first Integration Services project.