Failed to compiled scripts contained in the SSIS package deployed after running one week

0

We have target sql server as and build SSIS package in visual stdio 2019 but changed project target properties to target sql server 2014.[![Change target server version ][1]][1]

Things are going smooth for the whole week ,then all of sudden one of SSIS package throw below error.

Question if there is comp ability issue why packages not thrown this error in first place itself,any leads appreciated?

 Description: Failed to compiled scripts contained in the package. 
 Open the package in SSIS Designer and resolve the compilation errors. 
 End Error  Error: 2020-01-01 13:13:53.47     Code: 0xC0047062    
 Source: data flow task name  Update table name table in CRM 
 (Script Component name)    
 Description: MSB4018 - The "GenerateResource" task failed unexpectedly. 
 System.Runtime.InteropServices.COMException (0x800703FA): 
 Retrieving the COM class factory for component with CLSID {7B8A2D94-0AC9-11D1-896C-00C04FB6BAB2} 
 failed due to the following error: 800703fa Illegal operation attempted on a registry key that 
 has been marked for deletion. (Exception from HRESULT: 0x800703FA).    
 at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, 
 Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)  
 at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis,
 Boolean fillCache, StackCrawlMark& stackMark)     
 at System.Activator.CreateInstance(Type type, Boolean nonPublic)   
 at System.Activator.CreateInstance(Type type)    
 at Microsoft.Build.Tasks.GenerateResource.IsDangerous(String filename)  
 at Microsoft.Build.Tasks.GenerateResource.Execute()     
 at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
 at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__26.MoveNext(),
 "Path"\Microsoft.NET\Framework64\v4.0.30319\Microsoft.Common.targets, 
 2318, 5  End Error  Error: 2020-01-01 13:13:53.47     Code: 0xC0047062    
 Source: data flow task name Update table name table in CRM 
 (Script Component 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-01-01 13:13:53.55    
 Code: 0xC001F02A     Source: Package name      
 Description: Cannot create a task from XML for task "data flow task name", 
 type "Microsoft.Pipeline, {A28DC28C-BEA5-4208-AED4-12EB7A1DB123}" 
 due to error 0x80070057 "The parameter is incorrect.". 
 End Error  Error: 2020-01-01 13:13:53.56     Code: 0xC0010018    
 Source: data flow task name     
 Description: Failed to load task "data flow task name", type "".
 The contact information for this task is "Performs high-performance data extraction,
 transformation and loading;Microsoft Corporation; Microsoft SQL Server; 
 (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". 
 End Error  Error: 2020-01-01 13:13:53.56     Code: 0xC001F02A     Source: Incre_encount...  
 The package execution fa...  The step failed.```

[1]: https://i.stack.imgur.com/ZzHcG.png
visual-studio
ssis
sql-server-2017
asked on Stack Overflow Oct 15, 2020 by devesh • edited Oct 15, 2020 by devesh

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0