Thanks again for the response.

But would like to stick with Identity column on the temp table for now. Downloading and installing Misc components would create more need for migration...

Thanks for the replies.

Since I cannot alter either the source table or the target table to add/change column/properties, I ended up creating a temporary table with Identity column and...