I am importing a text file into a table that has an identiry col (used as primary key).
The text file does NOT contain the value for the identity col - I have 'enable identity insert' off (unchecked).
I would like sql server to auto generate the value as it inserts the rows (of course I would - after all it is an identity col).
Unfortunately, when I run the import it immediately complains about a null value for the identity col - I thought that unchecking 'enable identity insert' would be enough.
I have a few data transformations and none of those mention the identity col.