SqlBulkCopy Tutorial - Knowledge Base (KB)

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

Skip some columns in SqlBulkCopy

I'm using ...SqlBulkCopy... against two SQL Server 2008 with different sets of columns (going to move some data from ...prod... server to ...dev...). So want to skip some columns not yet existed / not yet removed....How can I do that? Some trick with ...C...

SqlBulkCopy ColumnMapping Argumentexception

the following code gives me an argumentexception saying, that the sourcecolumn 'e_partnerid', which is clearly in the csv, doesn't exist. I have a feeling that the Delimiter isn't set right or something like that and I tried changing the connectionstring ...

SqlBulkCopy fails on columns with spaces in them

I know that I need to wrap any column names with spaces in square brackets ...[].... I do this when I'm building my ...DataTable... columns....for (int i = 0; i < columns.Count; i++) { string colname = columns[i].ToString(); if (colname.Contains(" ...

SQL Bulk Copy by mapping columns dynamically

I read the file data into dataset and trying to bulk insert using SQL bulk copy by mapping the columns. All my column names in the database are in lower case which is created from my code....I am not sure why I get "The specified column doesn't exist in t...