Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS VSTA Script Editor Not Displaying in VS2015

I recently created a new SSIS project from within VS2015. I added a script task and when I click on the "Edit Script" button. Visual Studio opens; however, there's no solution

I'm running VS as administrator. I've tried re-installing Microsoft Visual Studio Tools for Applications 2015. With no luck. I did once get the solution to pull up after I re-installed Microsoft Visual Studio Tools for Applications 2015; however, the next time I clicked "Edit Script" there was nothing.

Is this a bug withing VSTA or has anyone else came across this issue?

"Edit Script" buttion from within the Script Component: enter image description here

No solution when clicking "Edit Script": No solution when clicking Edit Script

like image 981
BrentHS Avatar asked Jun 15 '16 14:06

BrentHS


2 Answers

Ok, for me this problem was due to Resharper - if I go under Tools | Options | Resharper and Suspend Now it allows the VSTA editor to display each time. Hope this helps

like image 82
Todd Langdon Avatar answered Sep 28 '22 06:09

Todd Langdon


I've solved the exact same problem today. In my case it was most likely caused by installing and removing several versions of VS/SSDT without some proper clean-up.

Go to Control Panel -> Uninstall or change a program -> "Microsft SQL Server Data Tools for Visual Studio 2015" -> Change -> Repair.

Repeat the steps for "Visual Studio Tools for Applications 2015".

This should only fix your installation and not affect any of your projects.

After restarting my Windows the problem was fixed!

like image 22
Dave Salamon Avatar answered Sep 28 '22 06:09

Dave Salamon