Having Trouble installing the SQL Server Integration Services Projects for Visual Studio 2019

tbforwork-6882 0 Reputation points
2024-06-03T14:26:48.4666667+00:00

I am having trouble installing. Need to do this offline without internet access. Have Visual Studio 2019 installed and was able to get the Analysis Services installed, but Integration Services is not installing:

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview

Getting this error:
Setup Failed

The pipe is being closed (0x800700E8)

Error log:

Error 0x800700e8: Process returned error: 0x800700e8

Error 0x800700e8: Failed to execute EXE package.

Error 0x800700e8: Failed to configure per-machine EXE package.

MainViewModel.OnPackageAction: Install Completed for package Microsoft Visual Studio Tools for Applications 2019 (id: VSTA2019)

Applied execute package: VSTA2019, result: 0x800700e8, restart: None

Error 0x800700e8: Failed to execute EXE package.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,721 Reputation points
    2024-06-03T17:14:33.92+00:00

    Hi @tbforwork-6882,

    Please try the following steps:

    • Disable all Anti Virus Software.
    • Insure sure you right Click and run the Installer as administrator.

    As seen here: https://www.prepar3d.com/forum/viewtopic.php?t=120606

    UPDATE

    Please try to launch at the command prompt (opened as Administrator) with an additional flag:

    Microsoft.DataTools.IntegrationServices.exe /repair

  2. ZoeHui-MSFT 34,756 Reputation points
    2024-06-04T06:29:07.4866667+00:00

    Hi @tbforwork-6882,

    Install error: 0x800700e8 - the pipe is being closed

    Here is a same issue, Install error: 0x800700e8 - the pipe is being closed, seems caused by an antivirus software preventing installer from doing its thing.

    You may have a double check.

    Regards，

    Zoe Hui

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