Importing unicode CSV file via DTS 
Author Message
 Importing unicode CSV file via DTS
I am trying to import a unicode CSV file into SQL Server 2000 table.  When I
attempt to perform the import I receive the error message "Matching Text
Qualifier not found", "Error Calling OpenRowset on the provider".  I am
doing this with other tables in the database but this one fails.  I suspect
it is related to a particular field that is an nvarchar of 2000 which may or
may not contain imbedded CR LF characters.  Does anyone have any ideas?


Sun, 28 Nov 2004 19:52:18 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Importing unicode CSV file via DTS

2. Importing a Text File via DTS and adding the File Name as a column via DTS

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

4. CSV import via DTS maps wrong fields

5. SQL 7.0 DTS Import of CSV files

6. DTS import csv - dynamic file name

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

8. SQL 7.0 DTS Import of CSV Files

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

10. SQL 7.0 DTS Import of CSV files

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

12. DTS - importing CSV file drops last record


 
Powered by phpBB® Forum Software