zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

2 results in tag: collation

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...
case-insensitive case-sensitive collation sqlbulkcopy sql-server
asked by Skippy Fastol

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...
collation sqlbulkcopy
asked by Mike K.

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!