SSIS错误无法在Window中找到"sgen.exe“

Question

我正在使用SQL Server和SSIS

在我的包中有调用的脚本任务在我的笔记本电脑中正确运行

但是，当我在服务器上部署包(未安装Visual)时，运行时会出现此错误

Date        9/26/2016 8:16:22 PM
Log     Job History (TestCallws)

Step ID     1
Server      CRM2016
Job Name        TestCallws
Step Name       test
Duration        00:00:02
Sql Severity    0
Sql Message ID  0
Operator Emailed    
Operator Net sent   
Operator Paged  
Retries Attempted   0

Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility  
Version 12.0.2000.8 for 32-bit  Copyright (C) Microsoft Corporation. All rights reserved.    
Started:  8:16:22 PM  
Error: 2016-09-26 20:16:24.45     
Code: 0x00000005     
Source: Script Task Script Task     
Description: Failed to compiled scripts contained in the package. 
Open the package in SSIS Designer and resolve the compilation errors.  
End Error  

Error: 2016-09-26 20:16:24.45     
Code: 0x00000005     
Source: Script Task Script Task     
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\Framework\v4.0.30319\Microsoft.Common.targets, 2769, 5  
End Error  

Error: 2016-09-26 20:16:24.47     
Code: 0x00000005     
Source: Script Task Script Task     
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: 2016-09-26 20:16:24.50     
Code: 0x00000004     
Source: Script Task      
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: 2016-09-26 20:16:24.50     
Code: 0xC0024107     
Source: Script Task      
Description: There were errors during task validation.  
End Error  DTExec: The package execution returned DTSER_FAILURE (1).  

Started:  8:16:22 PM  
Finished: 8:16:24 PM  Elapsed:  1.703 seconds.  
The package execution failed.  The step failed.

任何人都可以帮助我解决这个问题。

谢谢。

Answer 1

此错误是由于目标服务器上没有安装.Net SDK造成的。您的web任务需要生成序列化程序集。

您可以通过多种方式修复它--在目标服务器上安装.Net 4.0SDK。

替代-禁用生成序列化程序集选项。要做到这一点-打开您的脚本任务，转到编辑脚本代码，然后选择项目并打开其属性(与上下文菜单)。在生成页面上-选择生成序列化程序集并选择离开。然后在离开代码编辑器之前保存代码和项目。