How to install the SQL Server Integration Services, i.e., SSIS projects, in Visual Studio 2019?
This is a Microsoft tutorial about installing SSIS in Visual Studio 2019. Of course, 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 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. Time required: 15 minutes.
Table of Contents
1. Download the SSIS 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. Installing the SSIS extension in Visual Studio 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. Read this other tutorial on how to easily import XML documents into a database using SSIS.
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.
Good to hear, it’s great if it could help you installing the SSIS project.