Error installing SQL Server Integration Services Projects on VS 2022 17.8.5

Alen Cappelletti 891 Reputation points
2024-01-19T00:49:01.5066667+00:00

Hi all,

I try to install datatool extension (ssis project) into VS 2022 17.8.5 and always got errors.

User's image

I've tried several times and the executable remains stuck without progressing... and fails.

Below the first line where I got an Error... seems related to .exe.

I read also this post : https://learn.microsoft.com/en-us/answers/questions/915389/ssis-installation-error-unknown-error-(0x80131500)

P.S.: I followed this tips:

  1. Change Background Intelligence Transfer Service from Automatic with Delay to Automatic, click OK,
  2. Go to C:\ProgramData\Package Cache, and look for the most recent folders that contain SSDTISSingleton150.msi and SSDTSingleton140.msi, and delete those 2 folder.

I found more than one... but I found also many SSDTISSingleton.msi that I not deleted... maybe also those?

See image User's image

Obviously after my last attempt the first 2 reappeared... I would be inclined to delete them all and try again. What do you recommend?

THANSK, Alen

here full log: https://docs.google.com/document/d/1533udp3ndRh0TfRg5a8VStyG1RS7toGvhKs-guKrrIk/edit?usp=sharing

[4530:5134][2024-01-18T17:53:52]i000: MainViewModel.OnPackageAction: Install Started for package Microsoft SQL Server Integration Services Projects (id: ISVsix)
[17D0:53BC][2024-01-18T17:53:52]i301: Applying execute package: ISVsix, action: Install, path: C:\ProgramData\Package Cache\BC54F36977FB42B6CA482B1D511DCCCC96016D12\VSIXBootstrapper.exe, arguments: '"C:\ProgramData\Package Cache\BC54F36977FB42B6CA482B1D511DCCCC96016D12\VSIXBootstrapper.exe" /q /admin /instanceIds:"280d46e3" /logFile:"C:\Users\alenc\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20240118175245_1_ISVsix.log" "payload\Microsoft.DataTools.IntegrationServices.vsix"'
[4530:5134][2024-01-18T17:53:52]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 16
[17D0:53BC][2024-01-18T17:58:15]e000: Error 0x80131500: Process returned error: 0x80131500
[17D0:53BC][2024-01-18T17:58:15]e000: Error 0x80131500: Failed to execute EXE package.
[4530:5134][2024-01-18T17:58:15]e000: Error 0x80131500: Failed to configure per-machine EXE package.
[4530:5134][2024-01-18T17:58:15]i000: MainViewModel.OnPackageAction: Install Completed for package Microsoft SQL Server Integration Services Projects (id: ISVsix)
[4530:5134][2024-01-18T17:58:15]i319: Applied execute package: ISVsix, result: 0x80131500, restart: None
[4530:5134][2024-01-18T17:58:15]e000: Error 0x80131500: Failed to execute EXE package.
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,394 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Tianyu Sun-MSFT 24,886 Reputation points Microsoft Vendor
    2024-01-19T03:03:28.04+00:00

    Hello @Alen Cappelletti ,

    Thank you for taking time to post this issue in Microsoft Q&A forum.

    Please open %temp%\SsdtisSetup folder, search in Microsoft.DataTools.IntegrationServices_{timestamp}_ISVsix.log file.

    Follow the instructions here: Installation issues

    1. When the error is "Pre-check verification failed with warning(s): AnotherInstallationRunning.",
    • kill MSIExec.exe in task manager, and retry.
    1. When the error is "Object reference not set to an instance of an object.",
    • delete the broken instance folder "%ProgramData%\Microsoft\VisualStudio\Packages_Instances<InstallationID>"
    1. When the error is "Error 0x80091007: Failed to verify hash of payload",
    • delete C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7 and retry.
    1. When the error isn’t in the above list, you can zip %temp%\SsdtisSetup and send the logs to ssistoolsfeedbacks@microsoft.com for troubleshooting.

    Sincerely,

    Tianyu


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Alen Cappelletti 891 Reputation points
    2024-01-19T11:20:02.9+00:00

    I solved it after countless attempts to reconcile cache files and so on by physically deleting the VISUAL STUDIO folder and reinstalling from scratch. After this the SSIS extension was finally installed successfully. What a pain!

    0 comments No comments

  3. Alen Cappelletti 891 Reputation points
    2024-01-19T11:20:54.81+00:00

    I solved it after countless attempts to reconcile cache files and so on by physically deleting the VISUAL STUDIO folder and reinstalling from scratch. After this the SSIS extension was finally installed successfully. What a pain!

    0 comments No comments