JacekO - Thanks for this but it needed more (see my post about result) 

I did find out though why it worked on some tables and you were right - the client had REMOVED the IDENTITY value from some tables of the destination database!!! go figure!

All our tables have an identity column so this was not going to be an issue (or it would be an issue for all of them) so that is why i could not understand why it was not being consistent.

Who would guess a client would do something so crazy huh?