SQL 7.0 DTS Import of CSV Files 
Author Message
 SQL 7.0 DTS Import of CSV Files
I have been experiencing some problems importing CSV files using DTS.  It
does not always recognise the " characters around items of text the CSV
file.  Some columns get read including the quotes and others without.

Has anyone else experienced this problem and if so - has anyone found a
solution - or dare I even suggest it......but am I doing something silly??

Paul Humphris



Sun, 16 Sep 2001 03:00:00 GMT
 SQL 7.0 DTS Import of CSV Files

I just finished importing a whole slew of CSV files using DTS.  There were
several problems...

1.  Large Files needed to be done with BULK INSERT instead of DTS

2.  Some of our files, I had to edit them with a word processor and make
sure any end quotes were immediately followed by a column delimiter  "text",
rather than "text"    ,

3.  Just for academic purposes I will mention make sure to use the " option
in the text delimiter pull down box rather than the ' character.


Quote:
>I have been experiencing some problems importing CSV files using DTS.  It
>does not always recognise the " characters around items of text the CSV
>file.  Some columns get read including the quotes and others without.

>Has anyone else experienced this problem and if so - has anyone found a
>solution - or dare I even suggest it......but am I doing something silly??

>Paul Humphris




Tue, 25 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL 7.0 DTS Import of CSV files

2. SQL 7.0 DTS Import of CSV files

3. SQL 7.0 DTS Import of CSV files

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

5. Importing unicode CSV file via DTS

6. DTS import csv - dynamic file name

7. Importing unicode CSV file via DTS

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

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

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

11. DTS - importing CSV file drops last record

12. DTS and importing CSV/ascii files?


 
Powered by phpBB® Forum Software