Why is SSIS script component opening in Advanced mode?


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?



Advanced Editor



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?




1 Answer
1



Install SSDT2015 (SSIS part) alongside existing SSDT2017.






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

PHP contact form sending but not receiving emails

PHP contact form sending but not receiving emails I have created a contact form using PHP to send the data. The form seems to send fine as there are no errors and success message appears, however I am not receving the emails into the designated inbox. I am using PHPMailer as I originally tried just using the php 'mail' command which I now understand is a bit hit and miss. I cannot see why I would not be receving the emails so I would be very grateful for any help that could be given. I'm quite new to PHP so please be patient with me :) <?php use PHPMailerPHPMailerPHPMailer; use PHPMailerPHPMailerException; $msg = ""; if (isset($_POST['submit'])) { require 'phpmailer/src/Exception.php'; require 'phpmailer/src/PHPMailer.php'; require 'phpmailer/src/SMTP.php'; function sendemail ($to, $from, $body) { $mail = new PHPMailer(true); $mail->setFrom($from); $mail->addAddress($to); $ma...
Read more

PHP parse/syntax errors; and how to solve them?

Image
PHP parse/syntax errors; and how to solve them? Everyone runs into syntax errors. Even experienced programmers make typos. For newcomers it's just part of the learning process. However, it's often easy to interpret error messages such as: PHP Parse error: syntax error, unexpected '{' in index.php on line 20 The unexpected symbol isn't always the real culprit. But the line number gives a rough idea where to start looking. Always look at the code context . The syntax mistake often hides in the mentioned or in previous code lines . Compare your code against syntax examples from the manual. While not every case matches the other. Yet there are some general steps to solve syntax mistakes . This references summarized the common pitfalls: Unexpected T_STRING Unexpected T_VARIABLE Unexpected '$varname' (T_VARIABLE) Unexpected T_CONSTANT_ENCAPSED_STRING Unexpected T_ENCAPSED_AND_WHITESPACE Unexpected $end Unexpected T_FUNCTION… Unexpected { { Unexpected } } Unexpe...
Read more

iOS Top Alignment constraint based on screen (superview) height

Image
iOS Top Alignment constraint based on screen (superview) height Let's say for example i want my view's top margin be 30 px for iPhone 6s and for the other screen i want to change this constants from 30 to X where X is proportional to total height of screen i.e. 36.5 for iPhone X, 33 for iPhone 6s plus, 25 for iPhone SE And so on .... I know i can take @IBOutlet of NSLayoutConstraint and change it programmatically but what i want is i want to set it like aspect ratio that we have for height width like subview's heigh width is proportional it's superview it changes with super view's height and width @IBOutlet NSLayoutConstraint 2 Answers 2 The constraint you need here is the superView's centerY set multiplier to 0.5 if you want the top anchor's constant to be 0.25 of screen height from the top , so adjust the multiplier according to this logic which is height_of_scre...
Read more