Two issues after I upgraded to VS 2019: the large script task in SSIS will sometimes load in the VSTA and sometimes not VSTA is blank. Opening script task without project open corrupts task task.

Hall, John 1 Reputation point
2022-04-14T14:28:46.86+00:00

Two Issue in SSIS occurred after upgrading to VS 2019

  1. A large script task would sporadically not load in VSTA. It would just show a blank screen in VSTA. Once I broke the task into smaller script task which cause some redundant work, the small tasks would open just fine. The large script task would hang trying to debug and not execute because of the VSTA loading issue. Is there a know limit to the size of script task or is there a bug?
  2. The SSIS package that I am editing is targeted to SQL2016. If you open the package and script task thru the solution explorer folder view the script task will be corrupted and will not open when you open by first opening the project or run. This appears to be a bug. Is there something that can be configured to prevent this?
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,381 Reputation points
    2022-04-14T19:59:22.353+00:00

    Hi @Hall, John ,

    Based on your input, you can try to do the following:

    1. Update VS 2019 up to 16.11.12
    2. Go to the Control Panel, and right-click, Repair for the Microsoft Visual Studio Tools for Applications 2019

  2. ZoeHui-MSFT 34,581 Reputation points
    2022-04-15T01:43:54.82+00:00

    Hi @Hall, John ,

    It seems to be related with VSTA, please repair it via control panel.

    If the issue still occurs, please report the issue here to get more help.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.