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.

 

[Otis Mukinfus]

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

 

[Shawn Ferguson]

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

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

 

[Otis Mukinfus]

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



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