DTS import error from CSV file - cannot insert value NULL 
Author Message
 DTS import error from CSV file - cannot insert value NULL

Nick,
        So you want to insert values from your source system into your
destination db identity column.
What exactly is the error?
what are you using to insert the csv?
Have you any null values in your csv data in the column that will be inserted
into the identity field?

Allan


Quote:

>I'm having problems inserting data from a comma delimited text file into a
>new table. The field that is chucking back the error is an identity field,
>but everytime I try this procedure it fails. Allow auto identity increment
>is checked. Can anyone help me.

>This is my first ever dbase with sql server 7.0 so I am a little green.

>I appreciate any ideas or suggestions.



Wed, 30 Oct 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Dts Import Question:Importing Csv file in an existing SQL2000 table with row-level conditions

2. DTS Error: it tries to insert null into column when no not null is set

3. DTS Error: it tries to insert null into column when no not null

4. How to import CSV (comma separated value) ascii file

5. Importing unicode CSV file via DTS

6. SQL 7.0 DTS Import of CSV files

7. DTS import csv - dynamic file name

8. Importing unicode CSV file via DTS

9. DTS-CSV import file has dangling comma at the end of the record

10. SQL 7.0 DTS Import of CSV Files

11. SQL 7.0 DTS Import of CSV files

12. Importing a 66 gigabyte csv file into SQL2000 using DTS


 
Powered by phpBB® Forum Software