SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column

by

For the people stumbling across this question and getting a similar error message in regards to an nvarchar instead of money:

The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

This could be caused by a too-short column.

For example, if your column is defined as nvarchar(20) and you have a 40 character string, you may get this error.

Source

More Related Contents:

  1. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  2. Convert generic List/Enumerable to DataTable?
  3. How to read a CSV file into a .NET Datatable
  4. Convert JSON to DataTable
  5. Convert IEnumerable to DataTable
  6. Inner join of DataTables in C#
  7. How To Change DataType of a DataColumn in a DataTable?
  8. Best way to remove duplicate entries from a data table
  9. How I can filter a Datatable?
  10. How to select min and max values of a column in a datatable?
  11. Compare two DataTables to determine rows in one but not the other
  12. Export DataTable to Excel File
  13. How to compare 2 dataTables
  14. How to create a DataTable in C# and how to add rows?
  15. Convert DataTable to generic List?
  16. Get an IDataReader from a typed List
  17. Any way to SQLBulkCopy “insert or update if exists”?
  18. DataTable, How to conditionally delete rows
  19. sqlbulkcopy using sql CE
  20. DataTable equivalent in Java [duplicate]
  21. Best way to check if a Data Table has a null value in it
  22. Get Cell Value from a DataTable in C#
  23. How to change DataTable columns order
  24. How do I create a DataTable, then add rows to it?
  25. Sql Bulk Copy/Insert in C#
  26. Datatable select with multiple conditions
  27. DataTable internal index is corrupted
  28. How to make C# DataTable filter
  29. ComboBox.ValueMember and DisplayMember
  30. Why can’t I do foreach (var Item in DataTable.Rows)?

Leave a Comment