DTS-CSV import file has dangling comma at the end of the record 
Author Message
 DTS-CSV import file has dangling comma at the end of the record
I have a comma sep file to import as a scheduled job.  However, an extra
comma exists after the last column (field) in each record...as such DTS
wizard can't parse correctly.  How can I handle this?

example:

csv file:

a,b,c,d,<cr><lf>
e,f,g,h,<cr><lf>
...

Imported table

c1  c2  c3  c4
------------------
a    b    c    d
e    f    g     h
...

Thanks



Sat, 23 Feb 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DTS-CSV file import with dangling comma after last column

2. DTS - importing CSV file drops last record

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

4. CSV (comma delimited file) Import Utility?

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

6. Importing unicode CSV file via DTS

7. SQL 7.0 DTS Import of CSV files

8. DTS import csv - dynamic file name

9. Importing unicode CSV file via DTS

10. SQL 7.0 DTS Import of CSV Files

11. DTS import error from CSV file - cannot insert value NULL

12. SQL 7.0 DTS Import of CSV files


 
Powered by phpBB® Forum Software