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
User contributions licensed under CC BY-SA 3.0