SQL Server Integration Services Projects - Setup Failed.

The error Fatal error during installation (0x80070643) for the SSIS Projects extension is a generic setup failure. The recommended approach is to troubleshoot based on the specific error text in the SSIS extension log and then repair/reinstall the extension and Visual Studio as needed.

Follow these steps on the Windows Server 2019 machine with Visual Studio installed:

1. Open the SSIS extension installation log
   • Go to %TEMP%\\SsdtisSetup.
   • Locate the latest Microsoft.DataTools.IntegrationServices_{Timestamp}_ISVsix.log file.
   • Open it and look for the first error entry near the bottom of the file.
2. Match the error pattern and apply the corresponding fix In the log, if one of the following patterns appears, use the associated resolution: a. Pre-check verification failed with warning(s): AnotherInstallationRunning
   • Another Windows Installer operation (Windows Update, MSI, other VS component) is running or pending.
   • Wait until all other installations/updates complete.
   • Reboot the server to clear any pending installer state.
   • Run the SSIS Projects installer again.
   b. The file {filefullpath} already exists.
   • There are leftover SSIS extension files from a previous/failed install.
   • From an elevated command prompt, change to the Visual Studio IDE folder (adjust edition/path if not Community):

          cd "C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\Common7\\IDE"
          rm CommonExtensions\\Microsoft\\SSIS\\*
          rm PublicAssemblies\\SSIS\\*
          rm "PublicAssemblies\\Microsoft BI\\Business Intelligence Projects\\Integration Services\\"*
     

   • Run a Repair of Visual Studio via the Visual Studio Installer.
   • Restart the server.
   • Reinstall the SSIS Projects extension.
   c. Object reference not set to an instance of an object.
   • The Visual Studio instance registration is corrupted.
   • Delete the broken instance folder under %ProgramData%\\Microsoft\\VisualStudio\\Packages\\_Instances\\<InstallationID> that matches the affected VS instance.
   • Then rerun the SSIS Projects installer.
   d. Error 0x80091007: Failed to verify hash of payload
   • The downloaded payload is corrupted.
   • Delete the cache folder mentioned in the log, for example:
     • C:\\ProgramData\\Package Cache\\15160B731819F56D87A626F9A2777550340022D7
   • Re-run the SSIS Projects installer so it can download a fresh copy.
3. Ensure the SSIS extension is enabled in Visual Studio
   • After a successful install, open Visual Studio.
   • Go to Extensions > Manage Extensions > Installed.
   • Verify that SQL Server Integration Services Projects is present and Enabled.
   • If it is disabled, enable it and restart Visual Studio.
4. If the error in the log does not match any of the above
   • Zip the entire %TEMP%\\SsdtisSetup folder.
   • Use the SSIS tools feedback channel to provide the logs for deeper troubleshooting as suggested in the documentation.

These steps are supported for Visual Studio 2019 with the SSIS Projects extension on Windows Server 2019.

References:

• SSIS Projects extension for Visual Studio 2019 troubleshooting guide

clear all temp files. then try to install the sql server might be helpful.