Install SQL Server Integration Services in Visual Studio 2019

By:   |   Comments (36)   |   Related: More > Integration Services Development


SQL Server Integration Services is Microsoft’s powerful platform for implementing Extract, Transform and Load (ETL) solutions. It allows SQL Server Professionals to solve complex business intelligence tasks and work with a wide range of data sources. Microsoft provides a graphical tool for designing and developing Integration Services projects. This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install the SQL Server Integration Services development tool for the latest version of Visual Studio.


As mentioned above, Microsoft’s tool for developing Integration Services projects is named differently in different versions of the Visual Studio. For example, for the SQL Server 2008/2008R2 integration services, this tool was VS 2008’s Business Intelligence Development Studio (BIDS) and came with the SQL Server installation media. In VS 2010, the tool was renamed as the SQL Server Data Tools (SSDT) and shipped as a part of the SQL Server 2012 installation media. In VS 2012/2013, this tool was slightly renamed as SSDT-BI and needed a separate download. In VS 2015, it was called SSDT and needed a separate download. In VS 2017, this tool could be installed during the VS installation. It is worth mentioning that BIDS, SSDT-BI, and SSDT can be used not only for working with SSIS projects, but also SQL Server Analytical Services and SQL Server Reporting Services projects. Additionally, it is important to note that SSDT is backward compatible, which means that projects designed on the newer versions of SSDT can run on older versions of SQL Server.

Now, after that historical review, let’s move to the latest release of Visual Studio – VS 2019 and see what this version provides as an SSIS development tool. For this version of the VS, there is no standalone installer for SSDT. While in this version the core components of SSDT for creating database projects have remained integrated in Visual Studio, the Integration Services, Analysis Services, and Reporting Services projects have become just an extension of the VS. Thus, in order to install the tool for SSIS development, we first need to install VS 2019. Therefore, we will divide our article into two parts. In the first part we will describe the installation of VS 2019 and in the second part, will illustrate the SSIS’s extension installation.

Installing Visual Studio 2019

To download Visual Studio 2019 we will use the following link.

For our example, we will download the free, Community edition of this product:

Select Community Edition of Visual Studio 2019

Then, we will click on "Free download". After downloading the .exe file, we will double click on it to start the process:

Visual Studio 2019 Executeable File

The Visual Studio installer starts and after some time the following window is opened:

Visual Studio 2019 Installer

To add SSDT, we scroll down and choose "Data storage and processing". Then, we press the "Install" button and wait for the installation to complete:

Visual Studio Community 2019 Installer Progress

After installation, restart is required, so we press "Restart":

Visual Studio Community 2019 Reboot Required

After having our computer rebooted, we start Visual Studio:

Start Visual Studio Community 2019 Edition

On the next screen, just to keep our example simple, we just click "Not now, maybe later." instead of signing in:

Connect all developer services in Visual Studio Community 2019 Edition

After that, we choose the theme and click on "Start Visual Studio":

Visual Studio Community 2019 Edition Development Settings

Well, we have installed Microsoft Visual Studio 2019 on our computer. Now, it’s time to add the extension for developing Integration Services projects.

Adding the SSIS Projects extension to the Visual Studio 2019

When Visual Studio is opened, we click on "Continue without code" to add the necessary extension:

Add Extensions in Visual Studio Community 2019 Edition

In this window, we click on "Extensions" > "Manage Extensions":

Manage Extensions in Visual Studio Community 2019 Edition

In the search bar of the opened window, we type "Integration Services" to easily locate the extension. From the appeared list we choose "SQL Server Integration Services Projects" and press "Download":

Find SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

Then, we will execute the downloaded .exe file:

Execute SQL Server Integration Services Executeable File for Visual Studio Community 2019 Edition

The installation of the extension begins. Now, we will follow some simple steps. In the next window we click "OK":

Select Language for SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

After that, we click "Next" to continue:

Start Installation of SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

If you receive the following message, you probably have SQL Server Management Studio opened:

Installation Error for SQL Server Integration Services Installation in Visual Studio Community 2019 Edition

Close it and click "OK". The process should continue:

Loading Packages for SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

Finally, the setup is completed and we have our extension installed:

Setup Complete for SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

Now, we are ready to create Integration Services projects. In Visual Studio, we choose "Create a new project":

Create New Project in Visual Studio Community 2019 Edition

In the next window, we type "integration" to find "Integration Services Project" and click on it:

Create New SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

We choose a name for our project:

Configure SQL Server Integration Services Projects in Visual Studio Community 2019 Edition

Hence, it is ready! We opened the interface where we can design and develop SSIS 2019 packages:

Start Building SQL Server Integration Services Projects in Visual Studio Community 2019 Edition


To sum up, we reviewed the updates related to the tool for SQL Server Integration Services projects development in the VS 2019. As we have seen, in this version of the VS, the tool for designing SSIS projects is installed as an extension of the Visual Studio. We have also explored how to install Visual Studio 2019 and how to add the Integration Services Projects extension to it.

Next Steps

Please find additional, topic-related information using the following links:

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Sergey Gigoyan Sergey Gigoyan is a database professional with more than 10 years of experience, with a focus on database design, development, performance tuning, optimization, high availability, BI and DW design.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Monday, August 28, 2023 - 11:18:02 PM - Aishwarya J Back To Top (91515)
Thank you soo much , this article was very much helpful, I have one question to ask. How can we connect Mysql workbench to SSIS which we have installed in visual studio? Please let me know if you have any idea about it .

Thursday, July 20, 2023 - 1:40:12 PM - RUDRA PRASANNA RATH Back To Top (91413)

Tuesday, November 22, 2022 - 4:32:02 AM - HÜR AKDÜLGER Back To Top (90707)
Good and time saver article. Thank you Sergey Gigoyan.

Friday, November 4, 2022 - 2:44:09 PM - Todd Zdanowski Back To Top (90663)
right off the top of my head. thank you. thank you.
as of today, I am in a dead spot where when I look for visual student 2019 I click on the link and I get 2022...
and SSIS is not supported in 2022 yet.
Dead spot.
I love your instructions, great job.
please add one more link...

old versions...
I followed your instructions and at one point it kept giving me Visual studio 2022. just frustrating
but somewhere in your link I found the above link.
finished your instructions and I am on my way.
thank you again

Tuesday, July 19, 2022 - 2:04:08 PM - od Back To Top (90287)
Hi Sergey,
I appreciate your very nicely written article.
Do you have any similar document for the Enterprise edition, please?
Thank you,

Friday, July 8, 2022 - 2:09:32 PM - RB Back To Top (90245)
I get the install button grayed out i installed the community 2019 version of VS. But wheni try to install the integration srvices i get a gray button why?

Monday, July 4, 2022 - 4:14:55 PM - Frednel Jean Joseph Back To Top (90229)
Great article. wished I found this info a few weeks ago. I installed VS 2022 when it came out and realized I could not get SSIS to install. after reinstalling VS2019, I kept getting an error to close PerfWatson2.exe to continue. Now I am all good

Thursday, May 12, 2022 - 6:01:26 AM - Jan Potgieter Back To Top (90082)
Great and very useful article, thanks!

Thursday, October 28, 2021 - 3:47:07 PM - David Potter Back To Top (89379)
The only difference from your walk through, is that I have VS 2019 Pro and after running the exe file, I went back in and loaded SSAS and SSRS. When I try and open up a 2017 file it does not do an upgrade.. but lists it as unsupported. So how do we get 2019 to open up 2017 files?

Wednesday, October 6, 2021 - 4:18:21 PM - Elena Back To Top (89315)
Very useful instructions, thank you very much!

Monday, October 4, 2021 - 1:22:14 AM - Siroos Back To Top (89301)
That's great and useful. I could install SSIS 2019 without any problem.
I appreciate it.

Saturday, September 4, 2021 - 3:03:22 PM - Krishna Mohan G K Back To Top (89208)
This was perfect and came to the rescue at the most needed moment. Thank you!

Thursday, August 12, 2021 - 2:41:35 PM - Abhishek Back To Top (89122)
Thank you so so so much.

Friday, May 28, 2021 - 7:22:40 PM - Rawoof Shaik Back To Top (88762)
Very useful

Tuesday, May 25, 2021 - 11:47:05 PM - Abi Vu Back To Top (88740)
Thanks to this article. The installation on VS19 much less confusing

Wednesday, April 14, 2021 - 8:06:14 PM - Stan Back To Top (88543)
Thanks Sergey!

Tuesday, April 13, 2021 - 11:56:49 AM - Jigs Back To Top (88522)
Thanks that was really helpful instructions to install Integration Services in VS 2019

Monday, April 12, 2021 - 10:53:39 AM - Tom Back To Top (88513)
Thanks for posting this. Been using VS2019 with SSIS for a while now. I keep updating VS in hopes that the SSIS quarks will be worked out. Still nothing. I did run into an issue on one VS update where script components were not editable because the scrip window wouldn't launch, but an update to the SSIS extension corrected it.
I constantly restart VS when working in SSIS because of weird behavior. Mostly the editor comes up as a blank screen, no recovery just restart VS. I've also run into really odd stuff when the components inside the editor get close to the edges of the editor window.
I keep my conn mgrs at the bottom and sometimes trying to open a component at the bottom of the editor actually opens a conn mgr. So you gotta zoom out. I hope someday SSIS works well with VS. Odd behavior has been an issue since the launch of SSIS. It seems every time there's something new it breaks something else. At least now my enviro vars are in alphabetical order, yay! That only took 9 years.

Wednesday, March 31, 2021 - 4:59:57 PM - chachis Back To Top (88478)
Thank you man! I was in the verge of uninstalling it to get back to Visual Studio 2008 BIDS :D

Wednesday, March 17, 2021 - 3:31:18 AM - Jambo Back To Top (88423)
Excellent guide. Very helpful.

Friday, February 26, 2021 - 9:42:29 AM - Pravin Back To Top (88305)
Nice Help Bro.... Thanks

Monday, February 22, 2021 - 11:45:06 AM - Abrar Back To Top (88276)

Thursday, February 18, 2021 - 1:12:32 PM - Kathryn Back To Top (88262)
This was very clear and helpful. Thank you!

Sunday, February 14, 2021 - 12:42:22 PM - Dharmendra Back To Top (88235)
A big thumbs up

Sunday, February 7, 2021 - 11:37:17 PM - Syed Kamran Hussain Back To Top (88195)
To the point article, Thumbs Up!!

Thursday, January 28, 2021 - 2:32:02 PM - Marino Back To Top (88122)
Thank you.. this was right on time and to the point and led me through the forrest!

Saturday, January 23, 2021 - 1:02:24 AM - Shamsur Back To Top (88088)
@Sergey Gigoyan, Thanks for this post. Helped me a lot.

Thursday, November 12, 2020 - 10:54:47 PM - Joe Back To Top (87796)
In order to use with SQL Server 2109 you will need to run ’regsvr32 SQLTaskConnections.dll’ from a Command prompt to register the DLL.

Thursday, October 22, 2020 - 5:12:24 AM - mahesh makkimane Back To Top (86678)
How to install ssis 3.9 without internet and what are the dependencies required apart from Visual Studio 2019. I mean I was trying to install SSIS 3.9 on user machine but it fails because it is trying to download sql_adlsql and MS CrenditialValidator. Could you please guide how to do it.

Monday, September 28, 2020 - 11:53:19 PM - Mick Back To Top (86548)
You saved me! This is the best guide ever. I spent weeks trying to install the 2017 version it just won't go through

Tuesday, September 22, 2020 - 5:21:34 AM - Wim Back To Top (86513)
Has anyone figured out how to customize the SSIS toolbox?

I want to add a custom component from Konesans but I cannot figure out how to make it show up?

Thursday, September 17, 2020 - 6:08:23 AM - Nikunj Back To Top (86497)
when i try to install sql server integration service project
i will get
and other error you mention screen shot
i dont have SSMS open in my machine

Wednesday, September 2, 2020 - 8:05:47 AM - Russ Ward Back To Top (86404)
You rock! Thank you.

Friday, July 31, 2020 - 9:41:00 AM - Brad Back To Top (86224)

I think it is also worth noting in this post, which I believe is incredibly useful for developers who are migrating from one version to the next, that if you used to work with TFS as your source control service, you should probably plan on migrating to Azure Dev Ops when you move to 2019.

Thursday, July 16, 2020 - 7:37:49 AM - Armando Back To Top (86145)

Sergey, thanks for this article. I want to share with you all the audience that I installed VS 2019, SSDT and extensions with success. But, when I opened an integration services project package with a Data mining model training object on it a “No such interface supported” error came up. This package runs well in VS2017 and SSDT version 15.9.3. Any suggestion?

Thursday, July 9, 2020 - 9:04:20 AM - Ian F Back To Top (86112)

Sergey, great article, it is nice to have a well documented installation guide for 2019 because as you metioned the installation methods keep changing. Thanks!

get free sql tips
agree to terms