1
Answer

How to maintain identity column value during SQL bulk copy t

Nirav Prabtani

Nirav Prabtani

10y
2.2k
1
Hi,

I am doing sqlbulkcopy from one table to another table.
There are so many tables to do that.
I am copying data with for loop for each tables.

But, i am facing with an issue, whenever i copy data from source table to destination table than identity column value is getting changed.

Suppoose there is value like this in identity column of a source table
301
305
605

but when i copy data than it will imported in destination table like that
1
2
3

1) I have tried,
set identity_insert [tablename] ON
//COPY Data from source to destination
set identity_insert [tablename] OFF

2) I have also set SqlBulkCopyOption.KeepIdentity

Any solution will be highly appriciable.
Answers (1)