Cannot install SQL Server Integration Project in SQL Server 2019

MarkDAgosta-2552 0 Reputation points
2025-03-13T22:42:03.2633333+00:00

Running Windows 11 Enterprise, version 23H2, OS Build: 22631.4890.

Running new installation of "Visual Studio Professional 2019" v16.11.45

SQL Server Integration Services Projects extension - Setup Failed.

"Fatal error during installation (0x80070643)."

"Microsoft AS OLE DB Provider for SQL Server 2016: An error occurred during the installation of assembly 'Microsoft.VC80.CRT,type="win32",version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b"processorArchitecture="x86"'. HRESULT: 0x80070005"

I have a series of SSIS packages that will not load on this computer: incompatible project type.

I have seen many people asking this question and there are many responses, many of which I have tried without success. Has anyone successfully fixed this issue?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2025-03-14T01:24:20.1366667+00:00

    Hi @MarkDAgosta-2552,

    To open SSIS project in VS, you may need to install SSDT first.

    Install SQL Server Data Tools (SSDT) for Visual Studio

    And then you can install SSIS project.

    SQL Server Integration Services Projects

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

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