SSIS Script Task - Edit Script not working

Paolo Cos 31 Reputation points
2022-09-30T12:21:07.24+00:00

This is a common recurring issue on Microsoft SSIS Projects development IDE on Visual Studio Community 2019 (Windows 10): given a Script Task the edit button that should open a Visual Studio Intance (VSTA) to work on C# code do not react to the click. There are plenty of threads on internet about this topic, which is very common each Visual Studio new upgrade or whatever:

  • Upgrade VS to the latest version
  • Upgrade Sql Server Integration Services Projects to the latest version
  • Repair VSTA 2019 installation
  • Upgrade Windows SO
  • Uninstall and Install Sql Server Integration Service Projects

but this time none of the above is enough to solve. I am running VS 2019 Community 16.11.19 the latest version available as of today;

***UPDATE: after reinstalling Sql Server Integration Service Projects a click on the edit button opens an instance of Visual Studio but it is empty, the code is not available

246419-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
{count} votes

4 additional answers

Sort by: Most helpful
  1. Towhidul Tuhin 11 Reputation points
    2022-11-22T10:49:40.007+00:00

    Go to project properties, and make sure right TargetServerVersion is set. It was set to SQL Server 2019 in my case, but I didn't have this version installed on my local computer. Since I only have SQL Server 2017 installed on my local computer, changing it to SQL Server 2017 solved my problem.

    263025-image.png

    2 people found this answer helpful.
    0 comments No comments

  2. Yitzhak Khabinsky 25,201 Reputation points
    2022-09-30T12:58:57.56+00:00

    Hi @Paolo Cos ,,

    Please uninstall the Sql Server Integration Service Projects extension for VS 2019 v.4.*
    The v.4.0, 4,1, and 4.2 versions have many problems.

    And install its v.3.16
    Version 3.16 is the latest general availability (GA) version.

    1 person found this answer helpful.

  3. Michael Taylor 49,076 Reputation points
    2022-09-30T15:09:10.823+00:00

    You should use the Report a Problem feature in VS to report the issue to the team that is responsible for the SQL Integration Services extension that you're using. They will better be able to help you.

    In my experience the issue is that you have already opened the editor at least once and either didn't close it or started the debugger and it got confused leaving the editor either open in the background or VS thinking it is open when it isn't. In most cases I either alt-tab to the editor that was still running or use Process Explorer to kill the editor I couldn't see.

    0 comments No comments

  4. Bava Mani 0 Reputation points
    2023-03-23T21:12:25.6633333+00:00

    A simple in-build feature should not have this issue in the first place. Poor product design

    0 comments No comments