Top "Sqlbulkcopy" questions

Lets you efficiently bulk load a SQL Server table with data from another source.

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

I'm getting this exception when trying to do an SqlBulkCopy from a DataTable. Error Message: The given value of type …

c# datatable sqlbulkcopy
SqlBulkCopy Insert with Identity Column

I am using the SqlBulkCopy object to insert a couple million generated rows into a database. The only problem is …

c# sql-server sqlbulkcopy identity-insert
Mapping columns in a DataTable to a SQL table with SqlBulkCopy

I would like to know how I can map columns in a database table to the datatable in c# before …

c# sql datatable sqlbulkcopy
Sql Bulk Copy/Insert in C#

I am new to JSON and SQLBulkCopy. I have a JSON formatted POST data that I want to Bulk Copy/…

c# .net sql sqlbulkcopy
The given ColumnMapping does not match up with any column in the source or destination

I dont know why I am getting the above exception, please someone look at it .... DataTable DataTable_Time = new DataTable("…

c# sqlbulkcopy
Any way to SQLBulkCopy "insert or update if exists"?

I need to update a very large table periodically and SQLBulkCopy is perfect for that, only that I have a 2…

c# sql sql-server performance sqlbulkcopy
Bulk inserts taking longer than expected using Dapper

After reading this article I decided to take a closer look at the way I was using Dapper. I ran …

performance sqlbulkcopy dapper
SqlBulkCopy Not Working

I have a DataSet populated from Excel Sheet. I wanted to use SQLBulk Copy to Insert Records in Lead_Hdr …

c# asp.net sqlbulkcopy
C# Bulk Insert SQLBulkCopy - Update if Exists

Possible Duplicate: Any way to SQLBulkCopy “insert or update if exists”? I am using SQLBulkCopy to insert Bulk records How …

c#-4.0 bulkinsert sqlbulkcopy
Timeout expired with SqlBulkCopy

I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a …

.net asp.net sql sql-server sqlbulkcopy