Importing .CSV using DTS error

[dndaughtery]

I have a DTS package that is to import the data from a .csv file into a table in my database. I have set the columns to the specific fields but I get an error when I try run the DTS stating that the primary key field doesn't allow nulls. I looked at the design of the table and the primary key field is set as an identity and increments by 1. Why am I getting this error?

 

[fredericofonseca]

insert the .csv records into a temporary table.
then use a standard insert into ... select from to insert into the real table. This should solve your problem.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[jbenson001]

Remove the transformation that insertes into the identity column.

JIm