Visual Studio 2022: “Constructor on type 'DocumentWizardInitializer' not found” when editing SSIS Package Configurations

Question

I am unable to edit SSIS Package Configurations in Visual Studio 2022. Whenever I open SSIS → Package Configurations Organizer → Edit, Visual Studio throws an error and the configuration editor does not open.

The same SSIS project and the same XML configuration file open correctly in Visual Studio 2019 without any issues.

Environment

Visual Studio 2022 Community (64-bit) Version: 17.14.19

SSIS Extension: SQL Server Integration Services Projects 2022 Version: 17.0.1008.3

TargetServerVersion: SQL Server 2022

Other VS Extensions Installed:

Microsoft Reporting Services Projects

  Microsoft Analysis Services Projects
  

Error Message

Visual Studio shows:

An error occurred while a configuration was being edited.

Clicking “Show details” gives this full stack trace:

Constructor on type 'Microsoft.DataTransformationServices.Wizards.DocumentWizardInitializer' not found. (Microsoft.VisualStudio.Interop)

at System.RuntimeType.CreateInstanceImpl(...)

at System.Activator.CreateInstance(Type type, ...)

at Microsoft.SqlServer.Management.UI.WizardManager14.ExecuteWizard(...)

at EnvDTE.IVsExtensibility.RunWizardFile(...)

at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunAddNewItemWizard(...)

at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunWizard(...)

at Microsoft.DataTransformationServices.Design.DtsConfigurationsForm.editSelectedConfiguration_Click(...)

What I Have Tried

• Repaired Visual Studio

Removed & reinstalled SSIS 2022 extension

• Cleared VS cache (%AppData%\Microsoft\VisualStudio\19*)
• Tried different TargetServerVersions (2019/2022)

Ran VS as Administrator

Copied project to a clean machine

Checked that .dtsConfig XML is valid

The issue persists only in VS 2022. Everything works fine in VS 2019 on the same machine.I am unable to edit SSIS Package Configurations in Visual Studio 2022.

Whenever I open SSIS → Package Configurations Organizer → Edit, Visual Studio throws an error and the configuration editor does not open.

The same SSIS project and the same XML configuration file open correctly in Visual Studio 2019 without any issues.

Answer 1

Thanks for sharing the details!

This is a bug in SSIS extension for Visual Studio 2022. Some SSIS wizard components required for editing configurations are missing or not loaded properly in VS 2022.

Please try below steps to Fix:

1. Uninstall the SSIS 2022 extension from Visual Studio Installer.
2. Close Visual Studio and delete the cache folders: 

%AppData%\Microsoft\VisualStudio\17.0

%LocalAppData%\Microsoft\VisualStudio\17.0

%LocalAppData%\Microsoft\VSCommon

3. Restart your system.
4. Download and install the latest SSIS extension for Visual Studio 2022 from Microsoft.
5. Open Visual Studio 2022 in Run as Administrator mode.
6. In your SSIS project, set TargetServerVersion to SQL Server 2022 (or switch to 2019 once and back).
7. Try again: SSIS and next Package Configurations Organizer click the edit option.

After these steps, the configuration editor should open without errors.

If the issue still persists, you can temporarily edit configurations in Visual Studio 2019, where this problem does not occur.