I think the answer to your problem lies in the 'Enable Identity Insert' setting for the Transformation Data Task.

Right click the Transform Data Task and select Properties. Select the Options...