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?
Report this post to a moderator
|