Hi Phil Jaggard,
Thank you for sending us your concern.
Based on the error code you provided, I found the following line:
Failed to get the editor factory manager for cc84afbd-da02-46f4-8623-9f07e5569edb. at Microsoft.VisualStudio.PlatformUI.Packages.ShellService.EditorFactories.EditorFactoryRegistrar
You encountered this error when opening FailureModeDetails 1.dtsx. Since .dtsx files are SQL Server Integration Services (SSIS) packages, this indicates that Visual Studio cannot find or load the SSIS Designer editor.
Since you have done some troubleshoot step. I recommend trying the following additional actions:
Perform another deep uninstall using InstallCleanup.exe.
Manually delete any remaining Visual Studio folders in these paths:
-
%LOCALAPPDATA%\Microsoft -
%ProgramFiles(x86)%(Scroll down and remove any folders related to Visual Studio.)
- Open Control Panel and uninstall all C++ Redistributable packages.
- Download and install the latest version of Visual Studio 2022 Professional.
- During installation, ensure you select all necessary components for your project.
- Finally, download and install the SQL Server Integration Services (SSIS) extension.
I hope these steps help resolve the issue. If you need further assistance, please let me know in the comments.