SqlBulkCopy Tutorial - Knowledge Base (KB)

Case sensitivity in SQL Server column names

The DB I use has French_CI_AS collation (CI should stand for Case-Insensitive) but is case-sensitive anyway. I'm trying to understand why....The reason I assert this is that bulk inserts with a 'GIVEN' case setup fail, but they succeed with another 'Given...

SqlBulkCopy Failed to obtain column collation information for the destination table

I am getting this error when I try to write rows to a table via SqlBulkCopy and a DataTable object. ...Before going any further, let me say that I am aware of the Microsoft KB article below. Every post out there regarding this error references that articl...