SqlBulkCopy Tutorial - Knowledge Base (KB)

SQL bulk insert does not insert values properly into table

I have an Excel file(.xlsx) and I am trying to upload the content of the file into a Sql server table. Iam using the SQL bulk copy to bulk insert the data. The data gets inserted into the table but I find that the data is not inserted properly. ...Here is...

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

What's the fastest way to perform large inserts with foreign key relationships and preprocessing?

I need to regularly import large (hundreds of thousands of lines) tsv files into multiple related SQL Server 2008 R2 tables....The input file looks something like this (it's actually even more complex and the data is of a different nature, but what I have...

Import CSV data into SQL Server

I have data in the csv file similar to this:...Name,Age,Location,Score "Bob, B",34,Boston,0 "Mike, M",76,Miami,678 "Rachel, R",17,Richmond,"1,234" ...While trying to BULK INSERT this data into a SQL Server table, I encountered two problems....If I use FIE...

Weird "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Value' error

Software used: Windows 7 64 bit Ultimate, .Net 4, SQL Server 2008 R2....select @@version returns:...Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows...

SQL Bulk Copy not working with sparse column

I am using ...C#...'s ...SQLBulkCopy... class to insert multiple rows into ...SQL Server 2008 R2..... It is working for normal table.. but not working for the table which has ...sparse... column....Do I need to set any extra settings for ...sparse... colu...

SQL Bulk Upload, Merge and Delete records

I am creating an ASP.net web application, which receives a CSV file from the user, uploads the file to the server, bulk copies the data into a ...TempHoldingTable.... Then the code calls a stored procedure which contains ...Merge... statement to copy the ...

Retryable SQLBulkCopy for SQL Server 2008 R2

I am basically from database background and new to .net stuff. Please bear with me if my question sounds silly....I am using SqlBulkCopy in my code to transfer data from one SQL Server to other. But it is failing frequently due to network issues. To avoid...

SQL Trigger Update to Uppercase doesn't work using SQLBulkCopy Insertion

I'm using .NET ...SQLBulkCopy... to batch insert data into database. What I'm trying to do is to convert all specified string to uppercase when the data is inserted into the table. Here is my trigger script:...ALTER TRIGGER [dbo].[EmployeeTable_UpperCase]...