I'm using EPPlus in a c# script in SSIS, so have to target .NET framework 4.x With the latest EPPlus version, 7.0.8, I get the error:
Could not load file or assembly 'System.Runtime, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
OS: Windows Server 2019 Data Center, .NET framework version: 4.8.03761
Microsoft's suggested solution is to install SDK 7.0, but that didn't work
I've traced this dependency to Microsoft.IO.RecyclableMemoryStream (3.0.0.0, .NETCoreApp, v.6.0). Noting that among the older versions of EPPLus, versions 7.0.5 and 6.2.16 use an older version of the dependency: Microsoft.IO.RecyclableMemoryStream (2.3.2.0, .NETFramework, v4.6.2) I'm going to use 6.2.16, because it has the higher release date of the two.
Question: Of the two versions, 6.2.16, 7.0.5, which is the more up to date in terms of features and bug fixes? 6.2.16 has a more recent release date, but is a major version behind in naming. Also, is EPPlus considering releasing a NuGet with all updates, for software targeted to .NET 4.x like mine?
Thanks!
notes: I was able to use v7.0.8 when running SSIS from Visual Studio 2019 on my Windows 11 desktop. Running on the server failed with the error noted above.
There are several references to the missing System.Runtime, Version=6.0.0.0 problem in stack overflow that suggest retargeting the assembly reference in a config file, but I don't have that option in SSIS.