CRM, SSIS & Integrations ...configuring CRM as a non-coder
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
CRM, SSIS & Integrations
  • Home
  • Categories
    • Visual Studio
    • KingswaySoft
    • SSIS
    • JavaScript
    • CRM
    • SQL
    • ERP
    • Azure
    • How-to
    • Clubtimiser A/S
    • Office
    • Personal
  • About me
  • Privacy Policy
  • Home
  • SSIS
  • Visual Studio
  • Error installing SSDT for VS2017: Failed to acquire payload

Error installing SSDT for VS2017: Failed to acquire payload

May 3, 2018 Leave a Comment Written by Thomas

UPDATE 03-09-2018: The newest version of SSDT for Visual Studio 2017 works correct, and can now be installed. See the post here

I recently had to install VS2017 with KingswaySoft on a computer, and I ran into some issues in regard to the installation. After I had installed the Visual Studio software, I needed to install SSDT (15.5.0).

When I attempted to install the software, it threw an error, saying a file was missing. In the log, I could see the installer was attempting to download a file from Microsofts’ website. This was the error thrown:

Error 0x80070002: Failed attempt to download URL: ‘https://go.microsoft.com/fwlink/?LinkId=863935&clcid=0x409’ to: ‘C:\Users\tpl\AppData\Local\Temp\{E0D5BAFF-C46F-44AB-990B-C9CD44FC1B7B}\SSISOneDesigner2016’

Error 0x80070002: Failed to acquire payload from: ‘https://go.microsoft.com/fwlink/?LinkId=863935&clcid=0x409’ to working path: ‘C:\Users\tpl\AppData\Local\Temp\{E0D5BAFF-C46F-44AB-990B-C9CD44FC1B7B}\SSISOneDesigner2016’

Failed to acquire payload: SSISOneDesigner2016 to working path: C:\Users\tpl\AppData\Local\Temp\{E0D5BAFF-C46F-44AB-990B-C9CD44FC1B7B}\SSISOneDesigner2016, error: 0x80070002.

I checked if others had this issue, and after a while, the only suggested fix, was to run the installer as Administrator – this didnt help. I then tried following the link in the error, and I could freely download the software manually, and install it.

After the install, I tried running the installer for SSDT again, but it threw a new error:

Acquiring package: SQL_AS_AMO2012, payload: SQL_AS_AMO2012, download from: https://go.microsoft.com/fwlink/?LinkId=863929&clcid=0x409

Error 0x80070002: Failed attempt to download URL: ‘https://go.microsoft.com/fwlink/?LinkId=863929&clcid=0x409’ to: ‘C:\Users\tpl\AppData\Local\Temp\{7F3383A1-EA49-44F1-8CE0-B6501986CB91}\SQL_AS_AMO2012’

So, this is atleast progress, as it is new failing in a new download. I tried following this aswell, and I was then able to manually download and install the SQL_AS_AMO2012 file. After running the SSDT installer again, it then again threw a new error – this time, it was a registryfile it couldnt open.
The configuration registry key could not be opened (0x800703F3)

After a few days taking some steps forward and backwards, I ended up simply installing VS2015. I have successfully installed VS2017 previously, but this time it simply didnt work out.

If anyone knows what the issue I was facing was, feel free to contact me with a fix/workaround.

SSIS, Visual Studio
Bug, Log, SQL, SSIS
KingswaySoft Spring release v10
Fixed: Metadata error in Outlook plugin after upgrading to V9.0

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

The author

KingswaySoft MVP & Microsoft certified professional

My name is Thomas and I am a consultant at a company called netcompany A/S in Denmark. My primary focus is working with SSIS and KingswaySoft, where I perform integrations and datatranformations.

Click for more info

Recent Posts

  • Difference between two dates (SQL, SSIS and JavaScript)
  • Easy way to fetch row count for all tables in a SQL database
  • Create Application user in Azure for use in Dynamics 365
  • SSIS Basics: Merge join
  • Open dashboards in a new window

Useful information

  • Installation guide to KingswaySoft
  • Software download list
  • CRM Object Type Codes
  • CRM State & Status codes
  • Script Repository

Archives

  • May 2020 (1)
  • February 2020 (1)
  • January 2020 (2)
  • August 2019 (1)
  • May 2019 (1)
  • February 2019 (2)
  • January 2019 (2)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (3)
  • May 2018 (4)
  • December 2017 (2)
  • August 2017 (1)
  • February 2017 (1)
  • November 2016 (4)
  • October 2016 (1)
  • September 2016 (2)
  • August 2016 (5)
  • June 2016 (4)
  • May 2016 (3)

Useful blogs/links

Henrik Jensen, my good friend and colleague, has a blog regarding EVERYTHING Dynamics crm. He's got 50+ certifications, and he is a force to be reckoned with. Link to his blog (danish): crmblog.dk

KingswaySoft have developed an outstanding piece of software for datamanagement to and from CRM, and I can recommend this toolkit for nearly every situation. Link to their website: kingswaysoft.com

Tag Cloud

Azure Bug CRM 2015 CRM 2016 CRM Online Data Dynamics365 ERP Excel How To JavaScript KingswaySoft Log News Office Outlook Personal Solution SQL SSIS Visual Studio

Categories

  • Azure (2)
  • Clubtimiser A/S (1)
  • CRM (30)
  • ERP (2)
  • How-to (14)
  • JavaScript (3)
  • Office (3)
  • Personal (4)
  • SQL (2)
  • Visual Studio (23)
    • SSIS (23)
      • KingswaySoft (14)

Disclaimer

The information given on the website is tested on a mixture of live production environments and test environments, and therefore I cannot guarantee my information will work for you, if you attempt to follow my steps.
If you experience problems, please feel free to contact me.

@June 7th 2016