The maximum number of rows you can insert into a table depends on the precision that is set for the IDENTITY column.
If a table reaches that limit, you can either re-create the table with a larger precision or, if the table’s IDENTITY column is not used for referential integrity, use bcp to remove the gaps.