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

Martin 0 Reputation points
2025-11-16T00:51:56.0233333+00:00

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?

Developer technologies | Visual Studio | Extensions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Omkara Varshitha Kunapalli (INFOSYS LIMITED) 1,825 Reputation points Microsoft External Staff
    2025-11-17T09:24:56.08+00:00

    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.
          

     


Your answer

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