rockstar283 (6/7/2014)
Not possible.. You know the importance of an identity column right 🙂
I know what an IDENTITY column is, of course.
It seems that you are doing ETL from a source table to a target table and wish to preserve the values of source columns which are identities.
The obvious (at least, to me) solution is to not use an identity column as the target. That is based on the assumption that you are feeding transactional (source) data to a non-transactional data warehouse table of some sort (target).
If your target table supports both ETL and transactional processes, my assumption is wrong - and I'm guessing that that is the case here.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.