DTS from ASCII to table with identity column

[balves]

I'm trying to use DTS to import an ASCII, comma-delimited file. The destination table in SQL Server 7 has a primary key, Record_Id, which is an identity column. The DTS import fails. I have mapped the Record_Id field as "Ignore" and the checkbox for "Enable Identity Insert" is checked.

If I create another SQL table without the Record_Id field, the DTS import works just fine. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[balves]

I solved the problem by turning OFF the checkbox "Enable Identity Insert" and not messing with the Source/Destination transformation code on the Column Mappings and Transformations window of the DTS wizard. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer