In my previous article, I explained using a sample C# app on how to bulk insert data into SQL Server.
There is an inherent problem. Bulk Inserts work fine as long as there are no constraint violations. What if the primary key data already exists? Or, how do we update using BulkCopy?
These are some of the issues I ran into while doing some actual work.
I will soon post a solution to this problem…
Advertisement
