What do you do when you have to transfer data into an Identity column when you already have the identity values filled in the source? Do you?
a) change the schema to remove the identity column, transfer the data and then restore the schema
b) leave the identity column out of the insert query and let the Sql Server fill in the values. (not good when there are gaps)
c) use a script component
d) write insert statements that turn on IDENTITY_INSERT beforehand.
A. None of the above. Just check off the Keep Identity checkbox in the Connection Manager tab.