Why is SSIS script component opening in Advanced mode?
I'm trying to edit a previously working SSIS script component in Visual Studio. But when I open with 'Edit...' it instead opens the 'Advanced Editor'. This means that I can't get to the 'Edit script' button. How do I get i back?
The error list shows warnings like this:
Could not load type: Microsoft.DataTransformationServices.DataFlowUI.ADONETDestinationUI, Microsoft.DatatransformationServices.DataFlowUI, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91. Verify that the component editor is installed properly.
I use VS2017 and SSIS project target version is SQL Server 2016. The script component is written in 'Microsoft Visual C# 2015' (for historical reasons, and since higher versions has shown to be incompatible with target server).
It all used to work, but I think it broke when I uninstalled VS2015 (that I had not used for ages). I have both VSTA 2015 and VSTA 2017 installed, and have run repair on both. I have also tried to reinstall VSTA 2015 completely.
The SSIS XML file still contains the C# code when opened manually.
If I create a new script component in the project, it defaults to 'C# 2015' and has the same issue. If I create a new solution/project, the script component defaults to 'C# 2017' and the editor works.
Is this an issue with VSTA2015? Have I uninstalled other libraries/extensions by mistake?
Install SSDT2015 (SSIS part) alongside existing SSDT2017.
- Chart in Visual Studio Blend 2015
- exclude subdirectories in tsconfig.json
- How do I pass command line arguments to Python from VS in Debug mode?
- Is there a ReSharper annotation for regex highlighting?
- Adding a README.md file to a c# project in Visual Studio 2015
- Could not load file or assembly "System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
- NuGet can't resolve a dependency when updating a local package with dependencies from online repositories using Visual Studio 2015 Update 1
- Why am I getting an error before configuring a device in Visual Studio 2015?
- Use of Union with reference
- Problems publishing a website on smarterasp.net with csc.exe file included?
- How to make local nuget packages and reference them across solutions locally in dotnet core
- Visual Studio 2015 generate UML from code
- Cannot find corecrt.h: $(UniversalCRT_IncludePath) is wrong
- How can I set the 'copy to output directory' property in my nuspec file?
- Find and remove duplicate entries in csproj file
- Disable "You should only open projects from a trustworthy source" message in VS 2015
- How to switch between target frameworks for .NET Core projects in Visual Studio
- $ReturnValue in Watch window doesn't work in VS2015
- SAP Crystal Reports & VS 2015
- Why does intellisense and code suggestion stop working when Visual Studio is open?
- How to run Roslyn instead csc.exe from command line?
- Unable to start debugging. The startup project could not be launched. VS2015
- Visual Studio Shows code errors that don't exist
- Running two projects at once in Visual Studio
- Severity Code Description Project File Line Suppression State Error (downloading from Nuget for Xamarin)
- Upgrade from VS2015 to VS2022: Error LNK1104 cannot open file 'msvcprtd.lib'
- Can't Add View from Controller in VS 2015 : "There was an error running the selected code generator"
- VC compiler (Visual Studio 2015) can not link big (>2G) static lib file
- The default XML namespace of the project must be the MSBuild XML namespace
- A reference to 'YourProject' could not be added. An assembly must have a 'dll' or 'exe' extension in order to be referenced