zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

5 results in tag: columnmappings

SqlBulkCopyColumnMappingCollection: How to Use

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...
.net c# columnmappings sqlbulkcopy
asked by chobo2

SqlBulkCopy skips certain columns.

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...
c# columnmappings sqlbulkcopy sql-server sql-server-2008
asked by abatishchev

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 ...
columnmappings csv sqlbulkcopy
asked by OhSnap

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(" ...
c# columnmappings datatable sqlbulkcopy sql-server
asked by wham12

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...
c# columnmappings sql sqlbulkcopy
asked by user1046415

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!