The Destination table does not have an identity field. Hence, i would have to increment the PK value myself before inserting
This sounds like a nightmare waiting to happen for you!
Is there any reason why you can't add an auto inc onto your destination table as the current structure will be horrible to maintain..
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe