Jeff, Actually OP is using (*) when in the select statement something like this

Select IDENTITY(INT,1,1) AS RowID, *

into SomeTable

From Table

When we use this as the rule of thumb, identity column will be inherit, So only one identity column per table rule violates.

I would suggested OP to use Actual Column Name List and could skipped the identity column, but as he need the 'Actual values', i think ROW_NUMBER() Function will do.