Identity in sqlbulkcopy

Shawn Ferguson

How do you handle identity fields when using SqlBulkCopy ?

textfile - no identity to sql server identity field - only additional field in sql server.

Sep 28 '06 #1

Subscribe Post Reply

5620

Otis Mukinfus

On Thu, 28 Sep 2006 13:00:16 -0400, "Shawn Ferguson" <SF******@cscc.eduwrote:

>How do you handle identity fields when using SqlBulkCopy ?

textfile - no identity to sql server identity field - only additional field in sql server.

If it is autoincrement SQL server will take care of it the same as it would if
you inserted it from SQL.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Sep 28 '06 #2

Shawn Ferguson

It's giving me an error, column mapping not matching up with source. How can that be avoided?

>>Otis Mukinfus<ph***@emailaddress.com09/28/06 1:33 PM >>>

On Thu, 28 Sep 2006 13:00:16 -0400, "Shawn Ferguson" <SF******@cscc.eduwrote:

>How do you handle identity fields when using SqlBulkCopy ?

textfile - no identity to sql server identity field - only additional field in sql server.

If it is autoincrement SQL server will take care of it the same as it would if
you inserted it from SQL.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Sep 28 '06 #3

Otis Mukinfus

On Thu, 28 Sep 2006 13:55:42 -0400, "Shawn Ferguson" <SF******@cscc.eduwrote:

>It's giving me an error, column mapping not matching up with source. How can that be avoided?

>>>Otis Mukinfus<ph***@emailaddress.com09/28/06 1:33 PM >>>

On Thu, 28 Sep 2006 13:00:16 -0400, "Shawn Ferguson" <SF******@cscc.eduwrote:

>>How do you handle identity fields when using SqlBulkCopy ?

textfile - no identity to sql server identity field - only additional field in sql server.
If it is autoincrement SQL server will take care of it the same as it would if
you inserted it from SQL.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Make sure you didn't show a link to the primary key in the table. If you did,
the data will be one position off. If that's not the case, then I'm out of
ideas.

Anyone else seen this behavior?
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

Sep 29 '06 #4

Similar topics

SqlBulkCopy

by: Roy | last post by:

For SqlBulkCopy class, is there a way to add columns that are not persisted when WriteToServer(DataTable) is called? I have information to be cache temperarily with the record and not need to be...

C# / C Sharp

SqlBulkCopy and transactions

by: Oscar Thornell | last post by:

Hi, I am trying to enlist an instance of SqlBulkCopy into a transaction. When I executes and try to write to the database I´ll get an exception indicating a transactional deadlock. ...

C# / C Sharp

SqlBulkCopy fails during process exit

by: Cwappy | last post by:

I have a class that builds a DataTable and then, when the process is exiting, tries to write that DataTable to SQL Server 2000 via the SqlBulkCopy class. I know the process is exiting because I'm...

.NET Framework

SqlBulkCopy.WriteToServer SqlException

by: harleedavidson | last post by:

Using SqlBulkCopy.WriteToServer to upload a datatable and getting: System.Data.SqlClient.SqlException Line 1: Incorrect syntax near 'COLLATE'. Database Server is SQL2000, database in in 6.5...

C# / C Sharp

SqlBulkCopy class doesn't like nulls

by: Chris | last post by:

I have created a datatable from a csv file. One of the columns is an integer which sometimes can be blank. When it is blank I add a dbnull.value to the column when I add to the datatable. This...

ASP.NET

Looking for a SqlBulkCopy that can do UPDATE...

by: TheSteph | last post by:

Using : MS-SQL 2005 / .NET 2.0 / VS2005 I have two server with the same database def but different data. I would like to import data from Server2.TableA to Server1.TableA. If a row doesn't...

C# / C Sharp

SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns

by: Dave | last post by:

I'm using the SqlBulkCopy object to bulk insert large DataTable's into SQL Server. Its working well except tables with IDENTITY columns in them. When calling...

Microsoft SQL Server

SQLBulkCopy memory leak..

by: Amar | last post by:

Hi, I need to insert a large amount of records pretty frequently through my application. The quickest way to achive this seems to be SQLBulkcopy class. I have implemented the solution using the...

C# / C Sharp

SqlBulkcopy memory leak problem

by: Sergey Zenyuk | last post by:

In VB.net windows application I use following code implementing SqlBulkCopy import: Using connODBC As New OdbcConnection(ConnStrODBC) connODBC.Open() Dim dbcmd As New OdbcCommand(String....

.NET Framework

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware