SqlBulkCopy Tutorial - Knowledge Base (KB)
360 results in tag: c#
SqlBulkCopy Not Working
I have a ...DataSet... populated from Excel Sheet. I wanted to use SQLBulk Copy to Insert Records in ...Lead_Hdr... table where ...LeadId... is PK. ...I am having following error while executing the code below:...The given ColumnMapping does not match up ...
asked by Sandhurst
SqlBulkCopy Error handling / continue on error
I am trying to insert huge amount of data into SQL server. My destination table has an unique index called "Hash". ...I would like to replace my SqlDataAdapter implementation with SqlBulkCopy. In SqlDataAapter there is a property called "ContinueUpdateOn...
asked by Paladin
SqlBulkCopy and DataTables with Parent/Child Relation on Identity Column
We have a need to update several tables that have parent/child relationships based on an Identity primary-key in the parent table, which is referred to by one or more child tables as a foreign key....Due to the high volume of data, we would like to build ...
asked by James Hugard
Does sqkbulkcopy replace table schema?
I was inserting bulk data from C# code using sqlbulkcopy.There were 15000 records in temp_upload table.Now somehow the datatable in WriteToServer() method had just one column and 37 rows....After running it I found that the table just had 37 records.Initi...
asked by Rohit Raghuvansi
How can I perform an SqlBulkCopy (equivalent) using an ODBC connection in C#?
I am working on a project where I need to extract data from a MSSQL database table, and then insert the data into a table of the same structure on an AS400....The SqlBulkCopy would be the ideal candidate for this operation, but fails (understandably) beca...
asked by Matt
sqlbulkcopy using sql CE
Is it possible to use SqlBulkcopy with Sql Compact Edition e.g. (*.sdf) files?...I know it works with SQL Server 200 Up, but wanted to check CE compatibility....If it doesnt does anyone else know the fastest way of getting a CSV type file into SQL Server ...
asked by Mark H
ODBC and Windows Service
I'm new to windows services and... you guessed it, I’m a bit stuck. Let me paint the picture –...I’m running a timed service that use an OdbcDataReader and SqlBulkCopy to (1) archive the data (2) normalize the data on a SQL box. When I run this code...
asked by DNS
Converting String to bit before inserting into the database
Can anyone help in converting string value in C# to bit equivalent in Sql. I'm trying to bulkcopy the values of a datatable into Sql table. All the values I've in the datatable are in string format. When I try to bulkcopy to SQL table I'm getting an er...
asked by vix
Is there a way to use SqlBulkCopy without converting 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!
asked by Martin
SqlBulkCopy problem
i use SqlBulkCopy to insert data from OleDbDataReader (contains data from xls) to mssql-2005 i have a cloumn on the OleDbDataReader that contains number stored as text (in the xls) ...when i look into the mssql data i see null in that column all other c...
asked by eyalb
System.InvalidOperationException with SQlBulkCopy
I got the following error when executing bulkcopy....System.InvalidOperationException The given value of type String from the data source cannot be converted to type decimal of the specified target column. ...I use the following code....DataTable empTabl...
asked by ACP
WriteToServer: Connection property has not been initialized. sqlbulkcopy error
running sqlbulkcopy in c# and I get an error: WriteToServer: Connection property has not been initialized....it happens at the WriteToServer command. The connection is open....using (SqlBulkCopy s = new SqlBulkCopy(conn)) { foreach (DataTable dt in ds....
asked by Chris Hayes
SqlBulkCopy WriteToServer example. What am I doing wrong?
This might be long, but I want to explain my example...I got this Code:...#region [parent table] DataTable dtParent = new DataTable(); DataColumn dc; dc = new DataColumn(); dc.DataType = System.Type.GetType("System.Int32"); dc.ColumnName = "Id"; dc.Uniqu...
asked by Ash
Sqlbulkcopy doesn't seem to work for me
I have created a datatable and trying to insert that datatable through SqlBulkCopy but somehow it doesn't seem to work for me.... ...I got the error,...The given value of type DateTime from the data source cannot be converted to type decimal of the specif...
asked by ACP
SqlBulkCopy and Entity Framework
My current project consists of 3 standard layers: data, business, and presentation. I would like to use data entities for all my data access needs. Part of the functionality of the app will that it will need to copy all data within a flat file into a da...
asked by Skadoosh
Using SqlBulkCopy in a multithread scenario with ThreadPool issue
I'm facing a dilemma (!)....In a first scenario, I implemented a solution that replicates data from one data base to another using SQLBulkCopy synchronously and I had no problem at all....Now, using ...ThreadPool..., I implemented the same in a assynchro...
asked by Soulbe
SqlBulkCopy slow as molasses
I'm looking for the fastest way to load bulk data via c#. I have this script that does the job but slow. I read testimonies that SqlBulkCopy is the fastest.... 1000 records 2.5 seconds. files contain anywhere near 5000 records to 250k What are some of ...
asked by Chris Hayes
Questions About SQl BulkCopy
I am wondering how can do a mass insert and bulk copy at the same time? I have 2 tables that should be affect by the bulk copy as they both depend on each other. ...So I want it that if while inserting table 1 a record dies it gets rolled back and table 2...
asked by chobo2
Possible to get PrimayKey IDs back after a SQL BulkCopy?
I am using C# and using SqlBulkCopy. I have a problem though. I need to do a mass insert into one table then another mass insert into another table....These 2 have a PK/FK relationship....Table A Field1 -PK auto incrementing (easy to do SqlBulkCopy as str...
asked by chobo2
How to use SqlBulkCopyColumnMappingCollection?
I want to make one SqlBulkCopy method that I can use for all my bulk inserts by passing in specific data through the parameters....Now I need to do mapping on some of them. I don't know how to make a SqlBulkCopyColumnMappingCollection since that was my pl...
asked by chobo2
Page 1 of 18