can't add datatable to sqlbulkcopy

c# datatable sqlbulkcopy sql-server sql-server-2008

Question

This is my code

public static void InsertToDatabase(DataTable dataTable) {
    using (SqlBulkCopy sbc = new SqlBulkCopy(GetConnectionString())){
        sbc.DestinationTableName = tableName;
        sbc.WriteToServer(dataTable);
    }
}

This is the exception:

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

Is there any way to know on which column the exception belongs?

1
0
7/29/2014 8:42:22 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

There must be size mismatch. I mean the particular column in exception is having a size which is not able to hold the size of data in datatable.

what I mean is if column in exception is defined @DB end as say nchar(10) and you are trying to insert a data of size > 10 chars then also you will hit this exception.

Check and make sure the same.

2
7/30/2014 3:09:48 PM

Related Questions

Does SqlBulkCopy WriteToServer need all database columns in my DataTable?

I'm importing some data from a CSV, and it doesn't have all the fields my table does. I was making a DataTable with only the columns of my CSV, but I'm getting errors about converting from String to Boolean. None of the fields I'm adding are Boolean, so I'm assuming its a problem with the fields I left alone....Do I need to have a 1-1 mapping in ...
datatable sqlbulkcopy
asked by Thomas

Is it possible to utilize SqlBulkCopy without having to convert the data to a DataTable?

Is there a way to use SqlBulkCopy without converting the data to a DataTable? I have a list of objects (List) in RAM and I really don't want to use more memory to create the DataTable. Could it be possible to implement IDataReader on a List?...Thanks!
c# sqlbulkcopy sql-server
asked by Martin

System is thrown by SqlBulkCopy. When using WriteToServer, a FormatException occurs (DataTable)

The first problem I see is that you're going to have problems with the ...RowID... column; I expect it is trying to offset your data by one column at the moment - it ...doesn't know... that you are omitting it. You can either mess with the mappings, or (in your data-table) add a ...RowID... column (at index 0) - but note that SQL Server will ignore...
c# csv formatexception sql sqlbulkcopy
asked by Marc Gravell

When utilizing a datatable, the SqlBulkCopy WriteToServer method does not write any data.

All of the following processing takes place on the localmachine:...I have a source database (on the server) and a destination database (local machine). I have a list of tables that I wish to copy from the source to the destination, ie server-->local....I start by storing all the data from the server in a DataTable array using simple SELECT * statem...
c# sql sqlbulkcopy sql-server
asked by n4rzul

Getting an exception writing a boolean to sql using a datatable and SqlBulkCopy

I've fixed it, turns out it was a mapping problem. For some reason, all 20 other tables mapped completely fine, but this table didn't map correctly until I added the following:...bulk.ColumnMappings.Add("Ex", "Ex");
c# datatable sqlbulkcopy sql-server
asked by NibblyPig

How to add CsvHelper records to DataTable to use for SqlBulkCopy to the database

I was able to get this to work by adding a DataTable row and filling it in explicitly, instead of trying to add a CsvHelper record as a row....I used the following part instead of the similar part that is shown above:...foreach (var record in records) { DataRow row = dt.NewRow(); record.CompanyId = company.Id; row["Date"] = record.Date;...
.net csv csvhelper datatable sqlbulkcopy
asked by Justin Nafe

SqlBulkCopy into table that Default column values fails when source DataTable row has DBNull.Value

For part 1, "field that is NOT NULL with a DEFAULT", you should not be sending the field in the first place. It should not be mapped. There is no need to change that field to accept NULLs just for this. ...For part 2, "field that is NULL with a DEFAULT", that ...will... work to get the default value when passing in DbNull.Value, as long as you don'...
c# default-constraint null sqlbulkcopy sql-server
asked by Solomon Rutzky

SQLBulkcopy - Header of datatable getting inserted in the database table

The header of the datatable is getting inserted as a record in the table. I am incrementing the row number but still the header gets inserted. Could someone tell me what the issue is ? If you see the code below the I am doing rows.MoveNext.... XSSFWorkbook xssfwb; using (FileStream file = new FileStream(excelPath, FileMode.Open, File...
asp.net asp.net-mvc c# npoi sqlbulkcopy
asked by user3751248

SqlBulkCopy hangs without any exception or timeout when inserting a datatable with even a single row

Having an issue, basically I have a very large datatable (50,000 rows) and I am using SqlBulkCopy to insert it via this function I wrote:...public static void DoSqlBulkCopy(string connectionString, string destinationTableName, DataTable dataTable, int batchSize = 2000) { using (var bulk = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.Che...
c# sqlbulkcopy
asked by NibblyPig

Powershell inserting DataTable with SqlBulkCopy, that hold datetime columns

I'm trying to insert a predefined ...DataTable... into a SQL Server database, using ...Data.SqlClient.SqlBulkCopy.......There are different datatypes in the ...DataTable..., but the problem is with ...Datetime... columns....Like this one:...$Datatable.Columns.Add((New-Object System.Data.DataColumn 'mydate',([datetime]))) ...I have data in the colum...
datatable datetime powershell sqlbulkcopy sql-server
asked by Simon Bruun

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow