Reputation: 1
For some reason my SSIS script task in control flow and SSIS script component in data flow not working. If I drop an empty script and click on start it executes. But if I click on edit script and write simple code like
int a=10;
and click on build build is succeeded but when I click on start fails the package execution.
I tried with SSDT with visual studio 2017 and SSIS with Visual Studio 2019 with cannot load the script message as below for script task.
For script component in data flow task it throws the below error:-
System.IO.FileLoadException: Could not load file or assembly '15872 bytes loaded from Microsoft.SqlServer.TxScript, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Exception from HRESULT: 0xD0000003 File name: '15872 bytes loaded from Microsoft.SqlServer.TxScript, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.Runtime.InteropServices.COMException (0xD0000003): Exception from HRESULT: 0xD0000003 at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, Boolean fSkipIntegrityCheck, SecurityContextSource securityContextSource) at System.Reflection.Assembly.Load(Byte[] rawAssembly) at Microsoft.SqlServer.Dts.Pipeline.VSTAComponentScriptingEngine.GetScriptEntryPoint(String versionGuid) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserScriptInstance()
Upvotes: 0
Views: 1752
Reputation: 1
There is an issue in Visual studio that caused the error. Here is the latest fix posted by Microsoft on there website https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview enter image description here
Upvotes: 0