Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update

Mary T 0 Reputation points
2024-07-24T06:47:23.6766667+00:00

Hi MS,

We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed.

I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version from 3.1 as well to the latest version and I cannot uninstall from the control panel.

I tried different combinations of uninstalling/reinstalling Visual Studio then repairing/unistalling SQL Server Integration Services Projects from the control panel as well as using the downloaded .exe with no success. Latest attempt of uninstalling it from .exe file, gave me this error

[1C04:36E0][2024-07-26T10:23:02]i000: MainViewModel.OnPackageAction: Uninstall Started for package Microsoft SQL Server Integration Services Projects (id: ISVsix)

[35E0:356C][2024-07-26T10:23:02]i301: Applying execute package: ISVsix, action: Uninstall, path: C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7\VSIXBootstrapper.exe, arguments: '"C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7\VSIXBootstrapper.exe" /q /admin /instanceIds:"" /logFile:"C:\Users\xxxxxx\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20240726102256_1_ISVsix.log" /u:851E7A09-7B2B-4F06-A15D-BABFCB26B970'

[1C04:36E0][2024-07-26T10:23:02]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 12

[35E0:356C][2024-07-26T10:23:23]e000: Error 0x800703ea: Process returned error: 0x3ea

[35E0:356C][2024-07-26T10:23:23]e000: Error 0x800703ea: Failed to execute EXE package.

[1C04:36E0][2024-07-26T10:23:23]e000: Error 0x800703ea: Failed to configure per-machine EXE package.

[1C04:36E0][2024-07-26T10:23:23]i000: MainViewModel.OnPackageAction: Uninstall Completed for package Microsoft SQL Server Integration Services Projects (id: ISVsix)

[1C04:36E0][2024-07-26T10:23:23]i319: Applied execute package: ISVsix, result: 0x800703ea, restart: None

[1C04:36E0][2024-07-26T10:23:23]e000: Error 0x800703ea: Failed to execute EXE package.

Thank you,

Mary

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,187 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,590 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
227 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anna Xiu-MSFT 29,676 Reputation points Microsoft Vendor
    2024-07-24T13:30:14.2966667+00:00

    Hi @Timbol, Mary, 

    Welcome to Microsoft Q&A! 

    Please uninstall the “SQL Server Integration Services Projects” extension from Visual Studio “Extensions” menu > Manage Extensions > Installed

    Or, you can try to manually delete the SSIS folder: <VSInstanceRootDir>\Common7\IDE\CommonExtensions\Microsoft\SSIS.

    For VS2019, the default path is C:\Program Files (x86)\Microsoft Visual Studio\2019\edition\Common7\IDE\CommonExtensions\Microsoft\SSIS.

    Sincerely,

    Anna


    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.

     


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.