SqlBulkCopy knowledge Base | SqlBulkCopy Tutorial and Documentation

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....

c# sqlbulkcopy

asked by Chris Hayes

SQL Server 2005: Improving performance for thousands or Insert requests. logout-login time= 120ms

Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is working (I believe there is only one connection being pooled)...

bulkinsert flat-file import sqlbulkcopy sql-server-2005

asked by Rad

Processing a flat file in chunks using multiple threads using producer/consumer pattern and SqlBulkCopy into SQL Server DB

I hope you will bear with me. I wanted to provide as much information as I can. The main problem is how to create a structure (like a stack) that will be used by multiple threads that will pop a value and use it to process one big flat file and possibly ...

c# flat-file multithreading sqlbulkcopy sql-server

asked by Rad

add column while copying data in sql

I'm using SqlBulkCopy to bulk insert some records from one table into another table. The query is using a SqlDataReader to get the data. The one difference that matters (besides column order which is handled in the mappings) between the tables is that t...

sql sqlbulkcopy sqldatareader sql-server-2008

asked by nelsonwebs

SqlBulkCopy.WriteToServer not reliably obeying BulkCopyTimeout

I need to count sequential timeout exceptions from SqlBulkCopy. To test this, I use an external app to start a transaction & lock up the target table. ...Only on the first call does SqlBulkCopy throw a timeout exception when expected. We've tried using an...

.net c# sqlbulkcopy sql-server-2008 timeout

asked by Paul Smith

Rollback for bulk copy

I have an application that make a copy from my database by bulk copy class in c#....Can I rollback the bulk copy action in sql server when occur an exception?

bcp c# rollback sqlbulkcopy sql-server

asked by masoud ramezani

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...

c# sql sqlbulkcopy sql-server

asked by Ash

Get an IDataReader from a typed List

I have a ...List<MyObject>... with a million elements. (It is actually a SubSonic Collection but it is not loaded from the database). ...I'm currently using ...SqlBulkCopy... as follows:...private string FastInsertCollection(string tableName, DataTable ta...

c# linq sql sqlbulkcopy

asked by Jason Kealey

Database engine independent analog of SqlBulkCopy

What is the best database engine independent way to load a huge amount of data....While I'm using SQL Server I use SqlBulkCopy but want to untie from SQL Server

database-independent sql sqlbulkcopy sql-server

asked by abatishchev

incoherence in bcp command execution

I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error:...Starting copy... SQLState = S...

bcp sqlbulkcopy sql-server

asked by masoud ramezani

How to add gridview rows to a datatable?

I have a gridview which will contain some 'n' number of rows.... Now i want to add all rows of the gridview to a datatable which will be used for bulkcopy operation......I have found this ...http://www.codeproject.com/KB/aspnet/GridView_To_DataTable.aspx...

c# datatable gridview sqlbulkcopy

asked by ACP

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...

c# sqlbulkcopy sql-server-2005

asked by ACP

How to insert a DataTable with existing Key to a SQL Server Table

I am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields:...QuestionNumber (unique integer key)...QuestionText...QuestionType...In my SQL Server database I created a Table called "QUESTION" with the same fields. QuestionNumber ...

database datatable sqlbulkcopy sql-server vb.net

asked by Olga

How to get identities of inserted data records using SQL bulk copy

I have an ADO.NET ...DataTable... with about 100,000 records. In this table there is a column ...xyID... which has no values in it, because the column is an auto-generated ...IDENTITY... in my SQL Server database....I need to retrieve the generated IDs f...

ado.net database identity sqlbulkcopy sql-server

asked by Olga

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...

.net c# entity-framework sqlbulkcopy

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...

.net c# sqlbulkcopy threadpool

asked by Soulbe

How to prevent duplicate records being inserted with SqlBulkCopy when there is no primary key

I receive a daily XML file that contains thousands of records, each being a business transaction that I need to store in an internal database for use in reporting and billing. I was under the impression that each day's file contained only unique records, ...

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

asked by kscott

Bulkcopy inserts with DBCC CheckIdent

Our team needs to insert a cruel amount of data into our SQL Server 2008 database. We're looking for a good solution. Now we came up with one, but I have doubts with it, simply because it doesn't feel right. So I'm asking here if this seems like a good so...

batch-processing dbcc sqlbulkcopy sql-server sql-server-2008

asked by Dennis van der Stelt

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 ...