SqlBulkCopy error RRS feed

  • Question

  • I have a table on a SQL Server database that I'm trying to copy to another SQL Server database, and figured SqlBulkCopy was the perfect way to go. So I created the code, but when it runs I get the error:


    The locale id '0' of the source column 'Skillset' and the locale id '1033' of the destination column 'Skillset' do not match.

    Searching the net I found a site that says to fix this type of problem, you need to do column mapping, so I added mapping for all the columns. Example:


    copy.ColumnMappings.Add("Skillset", "Skillset");


    This still does not work (same error message). Any ideas before I convert it to do insert/updates?



    Thursday, June 7, 2007 7:58 PM