SSIS 2017- Nothing happens when clicking on "Edit Script" button

Question

I have Visual Studio 2017. SSIS and SSRS worked fine until yesterday.

But now, when I click on SSIS "Edit Script" button, nothing happens.

I have uninstalled SSDT and re-installed, but I am still having the problem.

Microsoft.SqlServer.ScriptTask.dll exists on these folders:

C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Tasks (and C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Tasks)
C:\Program Files\Microsoft SQL Server\150\DTS\Tasks (and C:\Program Files\Microsoft SQL Server\110\DTS\Tasks)
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\v4.0_11.0.0.0__89845dcd8080cc91 (and C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\v4.0_12.0.0.0__89845dcd8080cc91, C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\v4.0_13.0.0.0__89845dcd8080cc91 and C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\v4.0_14.0.0.0__89845dcd8080cc91)
Why out of a sudden the "Edit Script" button does not work, and how can I fix this issue ?

Answer 1

Hi @faujong ,

SSIS Script Task is using "Microsoft Visual Studio Tools for Applications".
If you cannot open Script Task editor, it means there is an issue with it.

Please go to Control Panel, find there "Microsoft Visual Studio Tools for Applications 2017".
Right mouse click, Change, Repair.

Answer 2

OMG..That fixed the issue. I am not sure why uninstalling and resinstalling the SSDT earlier didn't do the trick.
Thank you so much !