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

SqlBulkCopy Tutorial - Knowledge Base (KB)

9 results in tag: sql-server-2008-r2

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...
.net excel sqlbulkcopy sql-server-2008-r2
asked by Cdeez

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

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...
bulkinsert foreign-key-relationship sqlbulkcopy sql-server sql-server-2008-r2
asked by ibadibam

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...
bulkinsert sqlbulkcopy sql-server sql-server-2008 sql-server-2008-r2
asked by Malganis

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...
c#-4.0 sqlbulkcopy sql-server-2008-r2
asked by costa

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

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 ...
merge sql sqlbulkcopy sql-server-2008-r2
asked by learner

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...
.net c# sqlbulkcopy sql-server sql-server-2008-r2
asked by SumanKumar

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]...
sqlbulkcopy sql-server-2008-r2 triggers
asked by Koo SengSeng

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!