How to fix "Could not find or load a type. (Exception from HRESULT: 0x80131522)" in Visual Studio 2026

Question

I have installed visual studio 2026 and SQL Server Integration Services extension version 2.0 preview. But when I use slowly change dimensions component, the error "Could not find or load a type. (Exception from HRESULT: 0x80131522) (Microsoft Visual Studio)" appears. How can I fix this error?

Answer 1

Hello hope your doing well thanks for reaching out !

Close Visual Studio

• End all Visual Studio instances.
• In Task Manager, end any “devenv.exe” processes. Uninstall the SSIS 2.0 Preview extension
• Open Visual Studio.
• Go to Extensions > Manage Extensions > Installed.
• Find “SQL Server Integration Services” (2.0 Preview) and click Uninstall.
• Close Visual Studio to complete the uninstall. Install the latest stable SSIS extension (2022+)
• Open Visual Studio.
• Go to Extensions > Manage Extensions > Online.
• Search “SQL Server Integration Services Projects”.
• Install the latest stable “2022+” version (not a preview).
• Restart Visual Studio when prompted. Update Visual Studio 2026
• Open Visual Studio Installer.
• Select Visual Studio 2026 and click Update.
• Wait for the update to finish, then reboot if asked Clear Visual Studio’s MEF/component cache
  • Close Visual Studio.
    • Open File Explorer and go to:

      - %LOCALAPPDATA%\Microsoft\VisualStudio\
      
         - Open your VS 2026 instance folder (e.g., “17.0_xxxxx” or similar).
      
            - Delete the “ComponentModelCache” folder.
      
               - Optional: also delete the “Cache” folder if present. **Repair Visual Studio (if needed)**
      
               - Open Visual Studio Installer.
      
               - Choose Visual Studio 2026 > More > Repair.
      
               - After repair, restart your machine. **Reinstall SSIS extension (if it didn’t persist)**
      
               - Open Visual Studio > Extensions > Manage Extensions > Installed.
      
               - Confirm “SQL Server Integration Services Projects 2022+” is Installed.
      
               - If not, repeat Step 3 and restart Visual Studio. **Recreate the Slowly Changing Dimension (SCD) component**
      
                  - Open your SSIS project and package.
      
                     - Delete the existing SCD component.
      
                        - Drag a new “Slowly Changing Dimension” component onto the Data Flow.
      
                           - Reconfigure the wizard (source, keys, attribute change types). **Verify target versions and project settings**
      
                                 - In Solution Explorer, right-click the SSIS project > Properties.
      
                                       - Set TargetServerVersion to the SSIS version you use (e.g., SQL Server 2019 or 2022).
      
                                             - Save and rebuild the project. **Test on a stable environment if issue persists**
      
                                                      - Install Visual Studio 2022.
      
                                                               - Install the same “SQL Server Integration Services Projects 2022+” extension.
      
                                                                        - Open the package and confirm the SCD component loads without errors. **Collect logs if the error still appears**
      
                                                                        - In Visual Studio, go to Help > View Activity Log.
      
                                                                        - Check for TypeLoadException or assembly load errors.
      
                                                                        - Share the log with support to pinpoint the missing assembly  If you want, tell me your exact Visual Studio 2026 instance name (from %LOCALAPPDATA%\Microsoft\VisualStudio) and TargetServerVersion, and I’ll tailor the steps to your setup.