Post reply

MSB3086 - Task could not find "sgen.exe" using the SdkToolsPath

  • October 10, 2020 at 8:51 am

    #3795754

    Dear Members,

    I have upgrade SQL Server from 2016 to 2019 last Thursday. Everything works fine except some SSIS Packages. Here is the error:

    Message

    Executed as user: <My User name>. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4053.23 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 2:15:00 AM Error: 2020-10-09 02:15:07.79 Code: 0x00000005 Source: <Step Name> Description: Failed to compiled scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors. End Error Error: 2020-10-09 02:15:07.79 Code: 0x00000005 Source: <Step Name> Description: MSB3086 - Task could not find "sgen.exe" using the SdkToolsPath "" or the registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SDKs\Windows\v8.0A\WinSDK-NetFx40Tools-x86". Make sure the SdkToolsPath is set and the tool exists in the correct processor specific location under the SdkToolsPath and that the Microsoft Windows SDK is installed, C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Microsoft.Common.targets, 2769, 5 End Error Error: 2020-10-09 02:15:07.81 Code: 0x00000005 Source: <Step Name> Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2020-10-09 02:15:07.89 Code: 0x00000004 Source: <Step Name> Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2020-10-09 02:15:07.89 Code: 0xC0024107 Source: <Step Name> Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:15:00 AM Finished: 2:15:07 AM Elapsed: 6.891 seconds. The package execution failed. The step failed.

     

    I tried the following recommendation:

    https://stackoverflow.com/questions/34045326/msbuild-sgen-exe-is-missing

    https://developer.microsoft.com/en-us/windows/downloads/sdk-archive

    https://eysermans.com/post/getting-error-msb3086-task-could-not-find-sgen-exe-using-the-sdktoolspath-when-build-a-net-4-0-solution-with-teamcity-8-0

    https://westerndevs.com/sgen-not-found/

    but no use.

     

    Also I found the following solution:

    1.      Open your project in Visual Studio 2010, and then Right-click on your project file and select Package/Publish Settings.

    2.      Then click on the Build tab and scroll down to the Output section.

    3.      Change the Generate serialization assembly from "Auto" to "Off"

    4.      Save your settings and try building your project.

     

    As I am DBA, I don't know what might happen if "Generate serialization assembly" will be disabled.

     

    Any idea in this regard will be greatly appreciated,

    Sanaz.

     

     

    • This topic was modified 4 years ago by  sani.

  • October 11, 2020 at 9:10 am

    #3796014

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply