SqlBulkCopy Tutorial - Knowledge Base (KB)

How to keep row order with SqlBulkCopy?

I'm exporting data programatically from Excel to SQL Server 2005 using SqlBulkCopy. It works great, the only problem I have is that it doesn't preserve the row sequence i have in Excel file. I don't have a column to order by, I just want the records to be...

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

duplicate products added when importing csv files

I am using the code below to import the csv files onto sqlserver 2008, the issue is , its adding duplicate records onto the table , how can i check to avoid duplicate records import , below is the code which i am using , i have copied from somewhere , and...

Troubleshooting SqlBulkCopy not doing minimal logging

Based on the idea presented ...here..., I've created a ...QueuedDataReader... which wraps a ...ConcurrentQueue... in an ...IDataReader... so I can pass it to ...SqlBulkCopy... and 'stream' data into the database....It works ok, and pretty fast, but the lo...

Update previous record when i import from excel to sql database

I need help with this code. I am trying to import into SQL database from excel. A column is set to unique so that if it discovers duplicate data it ignores it. In this case instead of ignoring it I want it to update the data if there is an update. Here is...

C# SQL Bulk Copy: Column returning "null" halfway

When I am using SQL Bulk Copy, my columns return "null" halfway through the insert... ...The only thing I can think of is because of special characters such as ".../..." and "...-...". Is it at all possible to escape chars in SQL bulk Copy?...I've tried l...