System.Data.SqlClient / sni.dll in coded automation -> Unable to load DLL 'sni.dll'

[loginerror (Maciej Kuźmicz)]

Hi @rickard.nordstrom

This might not be the solution just yet, but more context can be found in this topic:

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies

Hey everyone, I’m currently developing a custom activity for Sql Server Bulk Insert using Microsoft.Data.SqlClient version 4.1.0. Encountering a confusing issue, let me elaborate. I’m including the project DLL via NuGet package and adding the Microsoft.Data.SqlClient version 4.1.0 in the Edit Dependencies of NuGet. Here are some key points to note: My activity requires a connection string as input for establishing a connection. I’m utilizing the Class Library (.NetFramework) project for act…