Edit script button i n Script transformation editor for SSIS 2019 project not working

Greg Booth 1,371 Reputation points
2021-12-13T18:41:33.937+00:00

We are running
a) Visual studio 2019 commjnity edition - version 16.11.5 with
SQL Server data tools - 16.0.62017 and
Sql server integration services - 15.0.2000.170

We create an ssis solution (taget = sql server 2019)
in the data flow, i add a Script component., language = c'2019, but when i press the "Edit Script" button, nothing happens.
Why is this ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,586 Reputation points
    2021-12-13T19:09:35.7+00:00

    Hi @Greg Booth ,

    SSIS Script Task/Component is using "Microsoft Visual Studio Tools for Applications".
    If you cannot open Script Task/Component editor, it means there is an issue with it.

    Please go to Control Panel, find there "Microsoft Visual Studio Tools for Applications 2019".
    Right mouse click, Change, Repair.

    - UPDATE -
    If Repair doesn't work, please try to download and install it from scratch:
    Microsoft Visual Studio Tools for Applications 2019

    0 comments No comments

  2. Greg Booth 1,371 Reputation points
    2021-12-13T19:16:17.83+00:00

    The repair fails. Log file says
    [2244:197C][2021-12-13T19:12:44]i001: Burn v3.7.4906.0, Windows v10.0 (Build 19042: Service Pack 0), path: C:\ProgramData\Package Cache{f3fbabb4-bcfb-45eb-8fff-9b784fd68c38}\vsta_setup.exe, cmdline: '/modify'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'EditionDisplayName' to value 'Microsoft Visual Studio Tools for Applications 2019'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'UseCurrentCEIP' to value 'true'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'InstanceIds' to value ''
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'RebootRequested' to value '0'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'ExecuteSecondaryInstaller' to value '0'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'BundleProgressKey' to value 'Software\Microsoft\VisualStudio\16.0\Setup\vsta\setup'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'MoreLanguageFwlinkId' to value '660926'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'VSEIPAndPrivacyFwlinkId' to value '660900'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'MinOsLevelFwlinkId' to value '660914'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'SolutionFwlinkId' to value '836350'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'HelpFwlinkId' to value '660902'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'IE10FwlinkId' to value '660904'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'Win81BlockFwlinkId' to value '660905'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'SHA256BlockFwlinkId' to value '660912'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'Win81PreRelBlockFwlinkId' to value '660906'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'UninstallMddInfoFwlinkId' to value '660908'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'ThirdPartyHelpFwlinkId' to value '660909'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing numeric variable 'UpdateXmlFwlinkId' to value '660911'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'NetfxProductVersion' to value '4.5.31110'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'ProfessionalVSVersion' to value '11.0.50727'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'ProductKey' to value 'VT2XGN96MGPGC23V98KJRX7VV'
    [2244:197C][2021-12-13T19:12:44]i000: Initializing string variable 'ProductSKU' to value ''
    [2244:197C][2021-12-13T19:12:44]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\AD_BOO~1\AppData\Local\Temp\dd_vsta_setup_(var.MajorVersion)_20211213191244.log'
    [2244:197C][2021-12-13T19:12:44]i000: Loading managed bootstrapper application.
    [2244:197C][2021-12-13T19:12:45]i000: Creating BA thread to run asynchronously.
    [2244:2134][2021-12-13T19:12:45]i000: Ux Started
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Loading LocalizableStrings.xml string from LocalizableStrings.xml
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Reset Result
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Current action: Modify
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'CurrentOperation' to value 'Modify'
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'IsLanguagePack' to value ''
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Current action: Modify
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'CurrentOperation' to value 'Modify'
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'CurrentRepairPackage' to value ''
    [2244:2134][2021-12-13T19:12:46]i000: Setting numeric variable 'HypervisorSupported' to value 1
    [2244:2134][2021-12-13T19:12:46]i000: Setting numeric variable 'HypervisorEnabled' to value 1
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Resume = Arp
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Restart = Prompt
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Relation = None
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Action = Modify
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Display = Full
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'RelationType' to value 'None'
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'DisplayMode' to value 'Full'
    [2244:2134][2021-12-13T19:12:46]i000: Setting numeric variable 'NetworkAvailable' to value 1
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'OriginalDisplayMode' to value 'Full'
    [2244:2134][2021-12-13T19:12:46]i000: Setting string variable 'OriginalDisplayModeSwitch' to value ''
    [2244:2134][2021-12-13T19:12:46]i000: MUX: Metrics: ShouldSendData=True
    [2244:2134][2021-12-13T19:12:47]i000: MUX: SetupAction: Modify
    [2244:2134][2021-12-13T19:12:47]i000: MUX: ProductVersion: 16.0.31110.01
    [2244:2134][2021-12-13T19:12:47]i000: MUX: ProductLanguage: 1033
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Branch: vsta16rel
    [2244:2134][2021-12-13T19:12:47]i000: MUX: OS: Windows 10 Enterprise
    [2244:2134][2021-12-13T19:12:47]i000: MUX: OSVersion: 10.0.19042.0
    [2244:2134][2021-12-13T19:12:47]i000: MUX: OSLanguage: 2057
    [2244:2134][2021-12-13T19:12:47]i000: MUX: OSArchitecture: AMD64
    [2244:2134][2021-12-13T19:12:47]i000: MUX: RecordVirtualMachineInformation version: intel - 6040000
    [2244:2134][2021-12-13T19:12:47]i000: MUX: RecordVirtualMachineInformation serialNumber: vmware-42 28 7b 1f 49 98 af 4d-99 7c 77 07 22 1d 47 1c
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Ux Initialized
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Aquiring mutex 'Global\vsta_setup_(var.MajorVersion)' with a timeout of 0 ms
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Mutex 'Global\vsta_setup_(var.MajorVersion)' ownership: True
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Seen existing cache mutex 'Global\vsta_setup_(var.MajorVersion) CacheMutex': False
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Aquiring mutex 'Global\vsta_setup_(var.MajorVersion) CacheMutex' with a timeout of 60000 ms
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Mutex 'Global\vsta_setup_(var.MajorVersion) CacheMutex' ownership: True
    [2244:197C][2021-12-13T19:12:47]i100: Detect begin, 11 packages
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Detection Phase
    [2244:197C][2021-12-13T19:12:47]i000: MUX: ---------------
    [2244:197C][2021-12-13T19:12:47]i000: Setting string variable 'netfxfullredist_43_DetectKey' to value '4.8.04084'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'netfxfullredist_43_DetectKeyExists' to value 1
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\12.0\professional'; variable = 'VstaCheck_Dev12ProExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_Dev12ProExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\12.0\devenv'; variable = 'VstaCheck_Dev12ShellExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_Dev12ShellExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\14.0\professional'; variable = 'VstaCheck_Dev14ProExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_Dev14ProExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\14.0\devenv'; variable = 'VstaCheck_Dev14ShellExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_Dev14ShellExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: Setting string variable 'IsInstalled' to value '1'
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vsta\Servicing\12.0\langs'; variable = 'VstaCheck_VSTA12LangsExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_VSTA12LangsExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vsta\Servicing\14.0\langs'; variable = 'VstaCheck_VSTA14LangsExists'
    [2244:197C][2021-12-13T19:12:47]i000: Setting numeric variable 'VstaCheck_VSTA14LangsExists' to value 0
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_dtcore_2013 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hosting_x86_2013 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hosting_amd64_2013 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_finalizer_2013 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_dtcore_2015 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hosting_x86_2015 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hosting_amd64_2015 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_finalizer_2015 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hostingcore_x86 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: vsta_hostingcore_amd64 to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i052: Condition '(CurrentOperation = "Repair") OR (CurrentOperation = "Uninstall") OR (CurrentOperation = "Modify")' evaluates to true.
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Adding package: VsixInstallEXE to package detect list
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_dtcore_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hosting_x86_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hosting_amd64_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_finalizer_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_dtcore_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hosting_x86_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hosting_amd64_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_finalizer_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hostingcore_x86, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: vsta_hostingcore_amd64, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:12:47]i101: Detected package: VsixInstallEXE, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Setup update feature is enabled. Evaluating conditions to determine whether to run setup update.
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Setup will not be updated.
    [2244:197C][2021-12-13T19:12:47]i052: Condition 'CompatibilityMode = 0' evaluates to false.
    [2244:197C][2021-12-13T19:12:47]i052: Condition 'NOT((VersionNT > v6.1) OR (VersionNT = v6.1 AND ServicePackLevel >= 1))' evaluates to false.
    [2244:197C][2021-12-13T19:12:47]i052: Condition '(NOT netfxfullredist_43_DetectKeyExists) OR (netfxfullredist_43_DetectKey < v4.5)' evaluates to false.
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Wait for Detect to complete
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Default tree items state:
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Default selectable items state:
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Non-applicable packages grouped by Selectable Items:
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Warning Block: ProcessBlock : Please close Visual Studio now to reduce the chance that a computer restart will be required later.
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Detect Completed
    [2244:2134][2021-12-13T19:12:47]i000: MUX: Detect Completed, now create view
    [2244:197C][2021-12-13T19:12:47]i000: MUX: Wait for View to be loaded
    [2244:197C][2021-12-13T19:12:48]i000: MUX: View loaded
    [2244:197C][2021-12-13T19:12:48]i000: MUX: Go to Blocker page.
    [2244:197C][2021-12-13T19:12:48]i199: Detect complete, result: 0x0
    [2244:2134][2021-12-13T19:13:28]i000: MUX: Go to Maintenance page.
    [2244:2134][2021-12-13T19:13:32]i000: MUX: Online feed url authoring not found
    [2244:2134][2021-12-13T19:13:32]i000: MUX: Changing action between Detect and Plan, rerunning detect to reevaluate the conditions
    [2244:2134][2021-12-13T19:13:32]i000: MUX: Current action: Repair
    [2244:2134][2021-12-13T19:13:32]i000: Setting string variable 'CurrentOperation' to value 'Repair'
    [2244:197C][2021-12-13T19:13:32]i100: Detect begin, 11 packages
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Detection Phase
    [2244:197C][2021-12-13T19:13:32]i000: MUX: ---------------
    [2244:197C][2021-12-13T19:13:32]i000: Setting string variable 'netfxfullredist_43_DetectKey' to value '4.8.04084'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'netfxfullredist_43_DetectKeyExists' to value 1
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\12.0\professional'; variable = 'VstaCheck_Dev12ProExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_Dev12ProExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\12.0\devenv'; variable = 'VstaCheck_Dev12ShellExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_Dev12ShellExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\14.0\professional'; variable = 'VstaCheck_Dev14ProExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_Dev14ProExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vs\Servicing\14.0\devenv'; variable = 'VstaCheck_Dev14ShellExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_Dev14ShellExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: Setting string variable 'IsInstalled' to value '1'
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vsta\Servicing\12.0\langs'; variable = 'VstaCheck_VSTA12LangsExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_VSTA12LangsExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\DevDiv\vsta\Servicing\14.0\langs'; variable = 'VstaCheck_VSTA14LangsExists'
    [2244:197C][2021-12-13T19:13:32]i000: Setting numeric variable 'VstaCheck_VSTA14LangsExists' to value 0
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_dtcore_2013 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hosting_x86_2013 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hosting_amd64_2013 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_finalizer_2013 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_dtcore_2015 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hosting_x86_2015 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hosting_amd64_2015 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_finalizer_2015 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hostingcore_x86 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: vsta_hostingcore_amd64 to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i052: Condition '(CurrentOperation = "Repair") OR (CurrentOperation = "Uninstall") OR (CurrentOperation = "Modify")' evaluates to true.
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Adding package: VsixInstallEXE to package detect list
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Reset Result
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_dtcore_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hosting_x86_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hosting_amd64_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_finalizer_2013, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_dtcore_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hosting_x86_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hosting_amd64_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_finalizer_2015, state: Absent, cached: None
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hostingcore_x86, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: vsta_hostingcore_amd64, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:13:32]i101: Detected package: VsixInstallEXE, state: Present, cached: Complete
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Setup update feature is enabled. Evaluating conditions to determine whether to run setup update.
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Setup will not be updated.
    [2244:197C][2021-12-13T19:13:32]i052: Condition 'CompatibilityMode = 0' evaluates to false.
    [2244:197C][2021-12-13T19:13:32]i052: Condition 'NOT((VersionNT > v6.1) OR (VersionNT = v6.1 AND ServicePackLevel >= 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:32]i052: Condition '(NOT netfxfullredist_43_DetectKeyExists) OR (netfxfullredist_43_DetectKey < v4.5)' evaluates to false.
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Warning Block: ProcessBlock : Please close Visual Studio now to reduce the chance that a computer restart will be required later.
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Detect Completed
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Wait for View to be loaded
    [2244:197C][2021-12-13T19:13:32]i000: MUX: View loaded
    [2244:197C][2021-12-13T19:13:32]i000: MUX: Go to Blocker page.
    [2244:197C][2021-12-13T19:13:32]i199: Detect complete, result: 0x0
    [2244:2134][2021-12-13T19:13:32]i000: MUX: Go to Progress page.
    [2244:2134][2021-12-13T19:13:32]i000: MUX: Updating progress percentages: Burn: 100, Secondary installer: 0
    [2244:2134][2021-12-13T19:13:46]i000: MUX: Go to Maintenance page.
    [2244:2134][2021-12-13T19:13:49]i000: MUX: Online feed url authoring not found
    [2244:2134][2021-12-13T19:13:49]i000: MUX: StartPlanWithoutUIPage
    [2244:197C][2021-12-13T19:13:49]i200: Plan begin, 11 packages, action: Repair
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Plan Phase Begin
    [2244:197C][2021-12-13T19:13:49]i000: MUX: ----------------
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Online feed url authoring not found
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev12ProExists = 1 OR (VstaCheck_Dev12ShellExists = 1 AND VstaCheck_VSTA12LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev12ProExists = 1 OR (VstaCheck_Dev12ShellExists = 1 AND VstaCheck_VSTA12LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition 'VersionNT64 AND (VstaCheck_Dev12ProExists = 1 OR (VstaCheck_Dev12ShellExists = 1 AND VstaCheck_VSTA12LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev12ProExists = 1 OR (VstaCheck_Dev12ShellExists = 1 AND VstaCheck_VSTA12LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev14ProExists = 1 OR (VstaCheck_Dev14ShellExists = 1 AND VstaCheck_VSTA14LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev14ProExists = 1 OR (VstaCheck_Dev14ShellExists = 1 AND VstaCheck_VSTA14LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition 'VersionNT64 AND (VstaCheck_Dev14ProExists = 1 OR (VstaCheck_Dev14ShellExists = 1 AND VstaCheck_VSTA14LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i052: Condition '(VstaCheck_Dev14ProExists = 1 OR (VstaCheck_Dev14ShellExists = 1 AND VstaCheck_VSTA14LangsExists = 1))' evaluates to false.
    [2244:197C][2021-12-13T19:13:49]i000: Setting string variable 'WixBundleLog_vsta_hostingcore_x86' to value 'C:\Users\AD_BOO~1\AppData\Local\Temp\dd_vsta_setup_(var.MajorVersion)_20211213191244_000_vsta_hostingcore_x86.log'
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Non-MSP vital package found: vsta_hostingcore_x86
    [2244:197C][2021-12-13T19:13:49]i052: Condition 'VersionNT64' evaluates to true.
    [2244:197C][2021-12-13T19:13:49]i000: Setting string variable 'WixBundleLog_vsta_hostingcore_amd64' to value 'C:\Users\AD_BOO~1\AppData\Local\Temp\dd_vsta_setup_(var.MajorVersion)_20211213191244_001_vsta_hostingcore_amd64.log'
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Non-MSP vital package found: vsta_hostingcore_amd64
    [2244:197C][2021-12-13T19:13:49]w321: Skipping dependency registration on package with no dependency providers: VsixInstallEXE
    [2244:197C][2021-12-13T19:13:49]i000: Setting string variable 'WixBundleLog_VsixInstallEXE' to value 'C:\Users\AD_BOO~1\AppData\Local\Temp\dd_vsta_setup_(var.MajorVersion)_20211213191244_002_VsixInstallEXE.log'
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_dtcore_2013, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hosting_x86_2013, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hosting_amd64_2013, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_finalizer_2013, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_dtcore_2015, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hosting_x86_2015, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hosting_amd64_2015, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_finalizer_2015, state: Absent, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hostingcore_x86, state: Present, default requested: Repair, ba requested: Repair, execute: Repair, rollback: None, cache: No, uncache: No, dependency: Register
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: vsta_hostingcore_amd64, state: Present, default requested: Repair, ba requested: Repair, execute: Repair, rollback: None, cache: No, uncache: No, dependency: Register
    [2244:197C][2021-12-13T19:13:49]i201: Planned package: VsixInstallEXE, state: Present, default requested: Repair, ba requested: Repair, execute: Repair, rollback: None, cache: No, uncache: No, dependency: None
    [2244:197C][2021-12-13T19:13:49]i299: Plan complete, result: 0x0
    [2244:197C][2021-12-13T19:13:49]i300: Apply begin
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Apply Phase Begin
    [2244:197C][2021-12-13T19:13:49]i000: MUX: -----------------
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Metrics: ShouldSendData=True
    [2244:197C][2021-12-13T19:13:49]i000: Setting string variable 'CEIPConsent' to value '/CEIPconsent'
    [2244:197C][2021-12-13T19:13:49]i000: Setting string variable 'SqmOption' to value '1'
    [2244:197C][2021-12-13T19:13:49]i000: MUX: Free Disk Space before install: SystemDrive C:\ 14725017600 bytes AppDrive C:\ 14725017600 bytes
    [2244:2134][2021-12-13T19:13:49]i000: MUX: Go to Progress page.
    [1A04:1EC0][2021-12-13T19:13:51]i360: Creating a system restore point.
    [1A04:1EC0][2021-12-13T19:13:51]w363: Could not create system restore point, error: 0x80070005. Continuing...
    [1A04:1EC0][2021-12-13T19:13:51]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{f3fbabb4-bcfb-45eb-8fff-9b784fd68c38}, resume: Active, restart initiated: No, disable resume: No
    [2244:197C][2021-12-13T19:13:51]i000: MUX: Vital packages to be installed: 2
    [2244:197C][2021-12-13T19:13:51]i000: MUX: Total packages to be installed: 3
    [2244:197C][2021-12-13T19:13:51]i000: MUX: Updating progress percentages: Burn: 1, Secondary installer: 0
    [2244:2424][2021-12-13T19:13:51]i000: MUX: Cache Begin
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: vsta_hostingcore_x86 at path: C:\ProgramData\Package Cache{E7A0CD34-1F9B-3496-ADB3-2F180D302F6A}v16.0.31110\packages\vsta_hostingcore_x86\vsta_hostingcore_x86.msi.
    [2244:2424][2021-12-13T19:13:52]i000: MUX: Source confirmed
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: cab9D11BAE11C8EDF380F5DC63624B6CC82 at path: C:\ProgramData\Package Cache{E7A0CD34-1F9B-3496-ADB3-2F180D302F6A}v16.0.31110\packages\vsta_hostingcore_x86\cab1.cab.
    [2244:2424][2021-12-13T19:13:52]i000: MUX: Source confirmed
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: vsta_hostingcore_amd64 at path: C:\ProgramData\Package Cache{8E7A3713-551D-333A-9271-10EF4D77A80F}v16.0.31110\packages\vsta_hostingcore_amd64\vsta_hostingcore_amd64.msi.
    [2244:2424][2021-12-13T19:13:52]i000: MUX: Source confirmed
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: cabE963DE3F8DA53D1CF0E02B86B8CA39FD at path: C:\ProgramData\Package Cache{8E7A3713-551D-333A-9271-10EF4D77A80F}v16.0.31110\packages\vsta_hostingcore_amd64\cab1.cab.
    [2244:2424][2021-12-13T19:13:52]i000: MUX: Source confirmed
    [1A04:1EC0][2021-12-13T19:13:52]i323: Registering package dependency provider: {E7A0CD34-1F9B-3496-ADB3-2F180D302F6A}, version: 16.0.31110, package: vsta_hostingcore_x86
    [2244:197C][2021-12-13T19:13:52]i000: MUX: ExecutePackageBegin PackageId: vsta_hostingcore_x86
    [1A04:1EC0][2021-12-13T19:13:52]i301: Applying execute package: vsta_hostingcore_x86, action: Repair, path: C:\ProgramData\Package Cache{E7A0CD34-1F9B-3496-ADB3-2F180D302F6A}v16.0.31110\packages\vsta_hostingcore_x86\vsta_hostingcore_x86.msi, arguments: ' MSIFASTINSTALL="7"'
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: VsixInstallEXE at path: C:\ProgramData\Package Cache\BB756D6C166746EEEFABABE770BFB5A25E9EA2E0\packages\VstaVsixInst.exe.
    [2244:2424][2021-12-13T19:13:52]i000: MUX: Source confirmed
    [1A04:1AAC][2021-12-13T19:13:52]i304: Verified existing payload: .vsix at path: C:\ProgramData\Package Cache\BB756D6C166746EEEFABABE770BFB5A25E9EA2E0\packages\Microsoft.VisualStudio.Tools.Applications.vsix.
    [2244:2424][2021-12-13T19:13:52]i000: MUX


  3. ZoeHui-MSFT 41,491 Reputation points
    2021-12-14T01:53:31.22+00:00

    Hi @Greg Booth ,

    This is a known issue that VSTA maybe corrupt by VS instance updating.

    Currently the workaround is repairing VSTA via control panel.

    If this does not work, go into C:\ drive and searched for "vsta_setup.exe"-->> "Microsoft Visual Studio Tools for Applications 2019 version "-->>run it for a try.

    Or like YitzhakKhabinsky said, download the VSTA.

    If the issue still could not be resolved, please report the issue here, the VS team will help deal with it.

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.