SQL Server SSIS -单击“编辑脚本”按钮时无React

zsohkypk 于 2022-11-28 发布在 React

关注(0)|答案(3)|浏览(137)

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 ?
Thank you

sql-server

来源：https://stackoverflow.com/questions/70306333/ssis-nothing-happens-when-clicking-on-edit-script-button

3条答案

按热度按时间

flmtquvp1#

这个答案奏效了！https://learn.microsoft.com/en-us/answers/questions/659573/ssis-2017-nothing-happens-when-clicking-on-34edit.html?childToView=659692#answer-659692
SSIS脚本责任使用得是“Microsoft Visual Studio Tools for Applications.”如果无法打开脚本责任编辑器，则意味着该编辑器存在问题.
请转到控制面板，找到“Microsoft Visual Studio Tools for Applications 2017”。单击鼠标右键，更改，修复。

赞(0）回复(0）举报 2022-11-28

pu82cl6c2#

这是一个引入Visual Studio 2019及其SSIS扩展的错误。该错误已得到解决。

卸载当前版本。
安装更新版本：

赞(0）回复(0）举报 2022-11-28

0lvr5msh3#

转到项目属性，并确保设置了正确TargetServerVersion在我案例中，它设置为SQL Server 2019，但我本地计算机上没有安装此版本由于我本地计算机上只安装了SQL Server 2017，将其更改为SQL Server 2017解决了我问题