Bulk insert and an identity column

(Kenneth Fisher) TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file must match the columns in the table unless you use a format file or a staging table.

Register to Read