How to generate ID automatically when doing import 1

[royyan]

I am importing a set of data from text file which doesn't have ID for records.
I want to import all data into a table and generate ID for each records automatically. The ID collum is Primary Key of the table. I set "allow identity insert" as true when I set up DTS. But it give me error message says that ID collum can't be "NULL"
Thanks!

 

[nigelrivett]

Don't set allow identity insert as you want sql server to generate it for you.
I usually create a view without the identity and import into that (and try bulk insert - it's faster and simpler).

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[royyan]

Thanks, nigelrivett. It worked.

 

[SoCalSam]

Thanks. I had the same problem and your tip solved it!