Target table contains Identity Column

[Chao]

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

 

[JayKusch]

On the transformation section of the import, you need to Un-Check the Create Identity seed box

Thanks

J. Kusch

 

[JayKusch]

As a follow-up, this is found on the "Select Sources and Views" window that comes up during your DTS import setup.

Thanks

J. Kusch

 

[Chao]

Thanks Kusch. It worked.