Since SAP migration, sapnco.dll is not found by VS 2019 code
Hi All,
I am using VS2019 - for building and running SSIS package. One of the SSIS package is using C# script that's where exactly i am facing issue
Recently the SAP server (from where the script was reading data) has been moved to cloud. I haven't made any changes in the code but since the migration happened we are facing below error:
Error:
System.IO.FileNotFoundException: Could not load file or assembly 'sapnco, Version=3.0.0.42, Culture=neutral, PublicKeyToken=50436dca5c7f7d23' or one of its dependencies. The system cannot find the file specified.
File name: 'sapnco, Version=3.0.0.42, Culture=neutral, PublicKeyToken=50436dca5c7f7d23'
at System.Reflection.RuntimeAssembly.GetExportedTypes(RuntimeAssembly assembly, ObjectHandleOnStack retTypes)
at System.Reflection.RuntimeAssembly.GetExportedTypes()
at Microsoft.SqlServer.Dts.Pipeline.VSTAComponentScriptingEngine.CreateScriptObjectHelper(Assembly scriptAssembly)
at Microsoft.SqlServer.Dts.Pipeline.VSTAComponentScriptingEngine.GetScriptEntryPoint(String versionGuid)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserScriptInstance()
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
Solution tried
- I have checked the dll, it is present at below path:
C:\Windows\Microsoft.NET\assembly\GAC_64\sapnco\
- In configuration manager, solution platform has been set to "Any CPU" for avoiding 64 and
32 bit issue.
Can you please help me what else to do or check to make my existing code work.