Solved it..

No need to set identity_insert ON and OFF before bulk copying.

SQLBulkCopyOptions.KeepIdentity takes care of this.

So, following code worked for me:

using (SqlBulkCopy bulkCopy =

new SqlBulkCopy(destinationConnection.ConnectionString,SqlBulkCopyOptions.KeepIdentity))