Issue with sqlbulkcopy

[NNR (Jack)]

Dear @ashokkarale

I have seen u have help a user with topic

System.DllNotFoundException: Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found. (0x8007007E)

Hello guys. So im trying to run a invoke code with ‘sqlclient.sqlbulkcopy’ that looks like this: Using connection As New System.Data.SqlClient.SqlConnection(connectionString) connection.Open() Using bulkCopy As New System.Data.SqlClient.SqlBulkCopy(connection) bulkCopy.DestinationTableName = tableName Try bulkCopy.BulkCopyTimeout = 60 bulkCopy.WriteToServer(dataTable) Catch ex As Exception out_ExceptionMessage = ex.Message …

But even i followed the step in the thread still facing the same issue

Could u help me on this ?

[JarrydScott]

Hi @NNR

This could be a few things. Let’s start with the externals. I understand you looked at this link already: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies

I see you can try and upgrade all DB packages in UiPath and retry. Also, If you recently converted a project from “Legacy” to “Windows,” ensure you are using the Microsoft.Data.SqlClient namespace instead of the older System.Data.SqlClient . Check the Imports tab at the bottom of your workflow and ensure Microsoft.Data.SqlClient is included.

If this doesn’t work - let’s try reworking your SQL script.

[ashokkarale]

@NNR

Can you share more details. What you are facing and your setup.