If you’re using Visual Studio 2019 with SSIS, you may encounter an error or two when you start. One error is “incompatible” tacked onto the name of your SSIS project in parentheses:
Another error you may encounter is found in the Migration Report, a local htm file that contains information about the the attenpted Visual Studio project migration:
Some of the details may read: “The application which this project type is based on was not found.” Here’s how to fix it:
How To Fix It
Times they are a-changin’. That’s what Bob sang back in the day. It’s true for installing SQL Server Data Tools development templates in Visual Studio 2019. Here’s one way to install SQL Server Integration Services (SSIS) templates:
1. Open Visual Studio 2019
Once open, click Extensions–>Manage Extensions:
2. Search / Download the SQL Server Integration Services Projects Extension
When the Manage Extensions window opens, type “Integration Services” in the search textbox in the upper right corner of the window. SQL Server Integration Services Projects should appear near the top of the list returned. Click SQL Server Integration Services Projects and then click the Download button:
3. Once Downloaded, Open
Open the downloaded file:
4. Follow the SQL Server Integration Services Projects Wizard
Click Next to continue:
Select your target Visual Studio 2019 installation and click the Install button:
You may get an error because Visual Studio is still open and you’re trying to update it (I did). Click the OK button, close Visual Studio, and click Install again:
The SSIS templates take a while to install. Once they’re installed you’ll see this window. Click the Close button:
5. Open or Create an SSIS Project
If you’ve attempted to open an SSIS project before, it may still open as “incompatible.” If so, right-click the project and click “Reload Project”:
You should now be able to develop SSIS using Visual Studio 2019!
Need Help Getting Started or Updating SSIS in Your Enterprise?
Enterprise Data & Analytics specializes in training and helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. We’ve earned our blood-, sweat-, and tear-stained t-shirts. Reach out. We can help.