This is my code with the following columns and in the DB, those columns are
SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, System.Data.SqlClient.SqlBulkCopyOptions.Default, transaction); bulkCopy.DestinationTableName = "Test"; bulkCopy.ColumnMappings.Add("Number", "Code"); bulkCopy.ColumnMappings.Add("Type", "Type"); bulkCopy.ColumnMappings.Add("Group", "Group"); bulkCopy.ColumnMappings.Add("Short Text", "ShortText"); bulkCopy.ColumnMappings.Add("Text", "Description"); bulkCopy.WriteToServer(dataTable);
I am trying to insert a whole data table in a DB, using bulk copy but I am getting this error:
The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
It may be caused by a too-short-column. If your ShortText column is defined as NVARCHAR(30) and you have a 40 character string, you may get that error. See here for example: http://forums.asp.net/p/1228890/2212376.aspx
I have another answer for this question, maybe it can come in handy for someone. If you have a String which contains
" (quotation mark), you get this error message too. At least I just got this error message, and I searched for the wrong row, and I found this. As I removed the quotation marks, the error disappeared.