To have the destination table assign the identity, DO NOT use the SqlBulkCopyOptions.KeepIdentity option. Instead, don’t map the identity from the source, and don’t extract it from source to send through to SqlBulkCopy.
Since SET IDENTITY_INSERT is a session sensitive, it is managed in buffer level without storing somewhere. This means we do not need to check the IDENTITY_INSERT status as we never use this key word in current session. Sorry, no help for this. Great question though 🙂 Source: Here Update There are ways maybe to do … Read more