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..
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe