SSIS in Visual Studio 2019, How to setup

I am new to using Visual Studio 2019. I want to use SSIS along with python. I have set up python installation but SSIS was not visible.

I also heard when people are using visual studio  they may encounter below errors

  • "incompatible" tacked onto the name of your SSIS project in parentheses
  • Migration Report, a local htm file that contains information about the attempted Visual Studio project migration
  • The application which this project type is based on was not found

Let's Fix It and Get SSIS extension in Visual Studio

  1. Open Visual Studio 2019 --> Once open, click Extensions–> Manage Extensions:

  1. 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:

  1. Once Downloaded, Open. Open the downloaded file: "Microsoft.DataTools.IntegrationServices.exe"

  1. Follow the SQL Server Integration Services Projects Wizard, Click Next to continue:

  1. Select your target Visual Studio 2019 installation and click the Install button:
    1. "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"

  1. The SSIS templates take a while to install. Once they're installed you'll see this window. Click the Close button:

  1. Open or Create an SSIS Project

  1. 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":

Conclusion: You should now be able to develop SSIS using Visual Studio 2019😊

No comments:
Write comments

Please do not enter spam links

Meet US


More Services