SQL Server Bulk Insert failing when called from .NET SqlCommand
- by Nick Wright
I have a stored procedure which does bulk insert on a SQL server 2005 database.
When I call this stored procedure from some SQL (passing in the name of a local format file and data file) it works fine. Every time.
However, when this same stored procedure gets called from C# .NET 3.5 code using SqlCommand.ExecuteNonQuery it works intermittently.
…