Since SAP migration, sapnco.dll is not found by VS 2019 code

Preeti Kumari 1 Reputation point
2022-07-05T05:29:48.637+00:00

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

  1. I have checked the dll, it is present at below path:

C:\Windows\Microsoft.NET\assembly\GAC_64\sapnco\

  1. 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.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,480 questions
SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
{count} votes