Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in