Bulk Copy error The given value of type String from the data source cannot be converted to type nchar of the specified target column.

Question

Hello I'm facing a problem when I try execute the follow code: SqlBulkCopy bulkData = new SqlBulkCopy(_trans.Connection SqlBulkCopyOptions.Default_trans); bulkData.DestinationTableName = TB_TMP_CONTRATOS; try { bulkData.WriteToServer(_dtContratos); bulkData.Close(); } catch(Exception e){} I´m receiving an exception at write to server that says The given value of type String from the data source cannot be converted to type nchar of the specified target column. I already look the number of columns field size and everything is ok. anybody can help me? Tks in advance

Kirtan Patel · Answer

Friend you need to Shrink log follow this article from Microsoft :) and please mark  Do you like this answer  check Box :) http://msdn.microsoft.com/en-gb/library/ms178037.aspx

Suthish Nair · Answer

Ganesh this is an old thread. Post your queries here: http://www.c-sharpcorner.com/Forums/AddPost.aspx?TSource=AddPost

ganesh nataraj · Answer

If the table having autonumber column then u need to add a column (of type integer) to your Dataset or Datatable

Mauricio Rosa · Answer

Kirtan Tks so much for you help I´m discussing about log with our DBA because the transaction is very big so is necessary increase the log size. Cheers Mauricio

Mauricio Rosa · Answer

Hello you were rigth the size of columns must be bigger then they were. But now I'm receiving another exception: The transaction log for database 'BTB_CORP' is full. To find out why space in the log cannot be reused see the log_reuse_wait_desc column in sys.databases Executing this select: select namerecovery_model_desclog_reuse_wait_desc from sys.databases where name='btb_corp' log reuse says: ACTIVE_TRANSACTION The recovery model is set to simple. Tks again

Kirtan Patel · Answer

Friend One more thing you check in your database that if you are receiving any column Like varbinary / Image like datatype and your Database is having nchar column for receiving it that will also cause problem because we cant tonvert the binary / Image to nchar as error you received tell this also so check and let me know if it helps you :) if it helps you then check  Do you like this answer check box :) please

Mauricio Rosa · Answer

Tks Kirtan There is any way to know wich line in my dataTable contains the biggest value? I will change the columns size and post a reply again. tks and brgds Mauricio

Kirtan Patel · Answer

Friend  That thing only occurs when your receiving Data is larger then the column you have in Database table where you copying tables :) make your columns Size bigger in Size it will solve your problem :) make sure once again :)