I followed lab4 of bulk insert process, which is step 7, but failed by reported
Unexpected NULL value in column1, even commanded out the KEEPIDENTITY. Did anyone
encounter same situation as me?
I had the same issue. Go to the Column Properties, set the 'Identity Specification' to Yes
for the primary key column in each table. After doing this the Bulk Insert process worked
thanks. I used the provided sql script to build the table then using the bulk insert would