Column mappings in SqlBulkCopy are case sensitive

  • Article

When you use SqlBulkCopy and set the ColumnMappings property, the column names are case sensitive regardless of the case sensitivity setting in target DB. A general error message "The given ColumnMapping does not match up with any column in the source or destination" would be thrown in such case, whch is very hard to identify what column is not matched. Refer to this article which also discusses this issue: https://stackoverflow.com/questions/438587/sqlbulkcopy-not-working.