SSDT 15.8 Failed to acquire payload - error 0x80070002

Ashish Kumbhare 6 Reputation points
2021-03-22T17:15:09.04+00:00

Hi, I am trying to install SSDT 15.8 on window 2019 server. I need SSIS feature only. I am getting error with URL. Its failing to download exe. When I checked same URL on other machine which local, I am getting 404 file not found message. I checked IE settings, enabled file download. I checked other URLs and able to download file. Also check enhanced security and disabled it. But still same issue. Few weeks back I able to install same version in another server. I used /layout and /repair options but it worked. I tried same here but I am not able to moved ahead. I was able to install other 2 features but not required SSIS one. There is no direct internet connection to server but we have proxy enabled and we able to install 2 features with this setup. CDC:238C][2021-03-22T13:00:06]w343: Prompt for source of package: VSTA2017, payload: VSTA2017, path: C:\Temp\payload\vsta_setup.exe [1CDC:238C][2021-03-22T13:00:06]i338: Acquiring package: VSTA2017, payload: VSTA2017, download from: https://go.microsoft.com/fwlink/?LinkId=2013980&clcid=0x409 [1CDC:238C][2021-03-22T13:00:07]e000: Error 0x80070002: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=2013980&clcid=0x409' to: 'C:\Users\Ashish\AppData\Local\Temp\2{79497CED-B86D-4D6B-AEAE-E29AE3FF53C4}\VSTA2017' [1CDC:238C][2021-03-22T13:00:07]e000: Error 0x80070002: Failed to acquire payload from: 'https://go.microsoft.com/fwlink/?LinkId=2013980&clcid=0x409' to working path: 'C:\Users\Ashish\AppData\Local\Temp\2{79497CED-B86D-4D6B-AEAE-E29AE3FF53C4}\VSTA2017' [1CDC:238C][2021-03-22T13:00:07]e313: Failed to acquire payload: VSTA2017 to working path: C:\Users\Ashish\AppData\Local\Temp\2{79497CED-B86D-4D6B-AEAE-E29AE3FF53C4}\VSTA2017, error: 0x80070002. [1CDC:238C][2021-03-22T13:00:07]i000: MainViewModel.OnPackageAction: Modify CompletedDownload for package Microsoft Visual Studio Tools for Applications 2017 (id: VSTA2017) [1CDC:2204][2021-03-22T13:00:07]e000: Error 0x80070002: Failed while caching, aborting execution. Installation trying to download exe from https://go.microsoft.com/fwlink/?LinkId=2013979 https://go.microsoft.com/fwlink/?LinkId=2013980&clcid=0x409 and I am getting 404 for both Please help

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

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,901 Reputation points
    2021-03-23T01:49:25.71+00:00

    Hi @Ashish Kumbhare ,

    We can download SSDT for Visual Studio (VS) 2017(15.8) in the following link:
    SSDT for Visual Studio (VS) 2017

    80379-ssdt-158.png

    Best regards,
    Mona

    ----------

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

    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.

    1 person found this answer helpful.

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.