Problem Description

I'm unable to use the Slowly Changing Dimension Wizard in Visual Studio 2022 with SSIS. I get different errors on subsequent attempts:

First attempt:

Method does not exist. (Exception from HRESULT: 0x80131513)
(Microsoft Visual Studio)

Program Location:
   at EnvDTE.IVsExtensibility.RunWizardFile(String bstrWizFilename, IntPtr hwndOwner, Object[]& vContextParams)
   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunAddNewItemWizard(String pszItemName, Int32 cFilesToOpen, String[] rgpszFilesToOpen, IntPtr hwndDlg)
   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunWizard(String wizardName, String newItemName)
   at Microsoft.DataWarehouse.DataWarehouseUtilities.RunWizard(String wizardName, IServiceProvider serviceProvider, Object[] stackParameters)
   at Microsoft.DataTransformationServices.DataFlowUI.SCDComponentUI.EditImpl(IWin32Window parentControl)
   at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)

Subsequent attempts:

Constructor on type 'Microsoft.DataTransformationServices.Wizards.DocumentWizardInitializer' not found.
(Microsoft Visual Studio)

Program Location:

   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, Object[] args)
   at Microsoft.SqlServer.Management.UI.WizardManager14.ExecuteWizard(wizardResult& wr)
   at EnvDTE.IVsExtensibility.RunWizardFile(String bstrWizFilename, IntPtr hwndOwner, Object[]& vContextParams)
   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunAddNewItemWizard(String pszItemName, Int32 cFilesToOpen, String[] rgpszFilesToOpen, IntPtr hwndDlg)
   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunWizard(String wizardName, String newItemName)
   at Microsoft.DataWarehouse.DataWarehouseUtilities.RunWizard(String wizardName, IServiceProvider serviceProvider, Object[] stackParameters)
   at Microsoft.DataTransformationServices.DataFlowUI.SCDComponentUI.EditImpl(IWin32Window parentControl)
   at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)

Environment

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

• SSIS Extension: SQL Server Integration Services Projects 2022

• Other Extensions Installed:

  • Microsoft Reporting Services Projects

  • Microsoft Analysis Services Projects

What I've Tried

1. Repaired Visual Studio 2022 using Visual Studio Installer

2. Uninstalled and reinstalled SQL Server Integration Services Projects extension multiple times

3. Ran Visual Studio as Administrator

4. Cleared Visual Studio cache:

   • Deleted %LocalAppData%\Microsoft\VisualStudio\17.0_[InstanceID]\ComponentModelCache

   • Deleted %AppData%\Microsoft\VisualStudio\17.0_[InstanceID]

Question

Has anyone else encountered this issue with the SCD Wizard in Visual Studio 2022? Is this a known bug with the current version of SSIS extension, or is there another solution I haven't tried?

Any help would be greatly appreciated!