SqlBulkCopy Tutorial - Knowledge Base (KB)

Error handling with SqlBulkCopy - could it be any harder?

Running very low on ideas here. I've got a case where I'm using SqlBulkCopy to pump data into a DB, and about halfway through I run into different exceptions (primary key violations, index violations, etc)....I've confirmed that the violations are in fact...

Azure SqlExceptions

I have a program that uploads about 1gb of data to a SQL Azure Database. I use a SqlBulkCopy to upload this data. I upload about 8,000,000 entities, on average 32,000 entities at a time, with a maximum of about 1,200,000 in one time....I am receiving a lo...

SqlBulkCopy Exception Doesn't Contain Column Name

If the DataTable passed into to SqlBulkCopy.WriteToServer() contains values that will fail to convert, I get an InvalidOperationException that displays the value that failed to convert. The column name doesn't display anywhere in the exception from what ...