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

SqlBulkCopy Tutorial - Knowledge Base (KB)

6 results for: in tag: import

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...
excel export import sqlbulkcopy sql-server
asked by roman m

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)...
bulkinsert flat-file import sqlbulkcopy sql-server-2005
asked by Rad

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...
c# csv import sqlbulkcopy
asked by Mr A

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...
import performance sqlbulkcopy sql-server sql-server-2008-r2
asked by Benjol

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# excel import sql sqlbulkcopy
asked by Umar E. Shaibu

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...
c# excel import null sqlbulkcopy
asked by Mokey

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