Florian Reischl (3/17/2009)
If you don't use an IDENTITY column you can import the date into a temp table and use the following statement to add an incremental id:
This should work, but it does not give the sequence ids according to the order of the input rows.
--Ramesh