Visual Studio 2019 16.9.0 SSIS Script Task - VSTA Wont Load

Anthony Green 111 Reputation points
2021-03-08T14:22:08.45+00:00

Just upgraded from 16.7.5 to 16.9.0 and within SSIS extension, using the script task, the "Edit Script" button no longer opens VSTA.

Anyone know of a way to get this working again?

How can I downgrade back to 16.7.5 until this is fixed?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,514 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
955 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,831 Reputation points
    2021-03-08T14:53:07.533+00:00

    Hi @Anthony Green ,

    Please go to the Control Panel and try to repair Microsoft Visual Studio Tools for Applications 2019

    75468-screenshot-2021-03-08-095149.png

    UPDATE
    Finally, Microsoft posted a fix:

    "...There is a regression in VS 2019 16.9 that will cause script task/component not work properly when editing script. VSTA team has released a new version to work around this issue. Please download the latest version of VSTA 2019 here and manually install it to work around the issue..."

    So the installation of the Microsoft Visual Studio Tools for Applications 16.0 will fix the issue.

    5 people found this answer helpful.

  2. Mark Libner 16 Reputation points
    2022-12-05T16:54:39.337+00:00

    This is an ongoing issue for me and my team every time we update VS. I just updated my VS 2019 to 16.11.21 and the SSIS script task won't launch VTSA. Sadly I have found the consistent fix to be uninstalling and then reinstalling SQL Server Integration Services Projects extension. It is a separate exe/download outside of VS.

    2 people found this answer helpful.
    0 comments No comments

  3. Michael Taylor 45,996 Reputation points
    2021-03-08T14:55:30.017+00:00

    There is a note on the extension page about this very issue. You need to roll back to the previous version.

    For some extensions you can go to the Manage Extensions section of VS and there is a revert option. At least in my case there is no revert option for SSIS extension. Therefore you'll have to uninstall the extension. Then run the installer for the older SSIS extension. The download links are on the above mentioned page.

    1 person found this answer helpful.

  4. Monalv-MSFT 5,891 Reputation points
    2021-03-09T07:44:50.757+00:00

    Hi @Anthony Green ,

    Please create new ssis package and drag new Script Task.

    We should wait for some minutes after clicking Edit Script.

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  5. Michael Taylor 45,996 Reputation points
    2021-03-10T14:43:10.05+00:00

    VS 16.9.1 has just released. It might solve this issue but it is not listed as one of the feedback issues that has been resolved.