SqlBulkCopy and column mappings

microsoft.public.dotnet.framework.adonet

4 May 2006 2:24 PM

Steve

Hey,

I'm replacing an old C++ DLL in our application that used BCP with an
SqlBulkCopy alternative.

The problem Iâ€™m having is that the column mappings seem to compare the
destination column with that of the actual table and fails when there is a
difference in case. This comparison seems to be performed based on the
current thread culture rather than the database collation. The old BCP
implementation on the other hand was either case insensitive all the time or
obeyed the database collation.

Is there a way to either take into account database collation or temporarily
change the CompareInfo on the threads current culture to perform case
insensitive string comparisons?

Thanks.
Steve.