C# BCP API

[Joe]

Hello,
I'm calling a stored procedure to bulk insert data but the procedure
doesn't like a unc address format being passed to it. I wondered if
anyone had tried to write an API to bcp as I think that could solve my
problem.

Regards,

Joe

Joe

 

[Frank Rizzo]

Most likely it has to do with the user context under which the RDBMS is
running. That user probably has no permissions to the UNC share.

Regards

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi ,

Maybe it's permission what the process is lacking.

The approach I used to bulk insert is creating a DTS package and later call
it from code, you can update the source/target directly from the code so
it's reusable. let me know if you want some code snips

cheers,