SqlBulkCopy Tutorial - Knowledge Base (KB)

batch size of sqlbulkcopy in relation to number of rows in datatable

Do i need to ensure that each batch is completely full? ie if i had a datatable with 12028 rows, could i just use a batch size of 10k and it would automatically create 2 batches, 1 with 10k in and 1 with 2028 in?...Thanks.

sqlbulkcopy with transactions and notifyafter

I have the following code, which im trying to use to test out if its possible to have transactions and a notifyAfter property used to raise an event(i have already tried substituting the event for one i create/raise myself but it only gets raised after al...

SQLBulkCopy with Identity Insert in destination table

I am trying to insert a Generic list to SQL Server with SQLBulkCopy,...And i have trouble wit Identity Field...I wan t my destination table to generate identity field How should i handle this, here is my code...using (var bulkCopy = new SqlBulkCopy(Config...

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 can I perform on update (rather than an insert) on records that already exist? Is this possible with ...SQLBulkCopy...?....

Is it possible to do data type conversion on SQLBulkUpload from IDataReader?

I need to grab a large amount of data from one set of tables and SQLBulkInsert into another set...unfortunately the source tables are ALL varchar(max) and I would like the destination to be the correct type. Some tables are in the millions of rows...and ...

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

How to add new column in SQL Server using SqlBulkCopy which is not present in Excel using asp.net

I am creating an application which will upload data from Excel to SQL Server using ASP.NET. I know how to upload Excel data using ...SqlBulkCopy.... But I am trying to upload some extra data for the table column (...addeddate..., ...addedby......etc) whic...