ExamNotes.net  -  IT certification portal

ForumsCertResearchTop sitesNewslettersFree email
HomeRegister


Exams Notes
Practice exams
Exam games
Questions by email
Online training
Training videos
College degrees
Boot camps
Book store
Links directory
Tell a friend
For webmasters




General discussions > Public newsgroups > microsoft.public.sqlserver.server > Importing unicode CSV file via DTS

Show a Printable Version
Email This Page to Someone!
Receive updates to this thread



Author Importing unicode CSV file via DTS
Michael Fenske
Guest




Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A
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

Old Post 06-23-02 02:32 AM
Reply w/Quote Edit/Delete Message IP: Logged
All times are GMT.
Post new thread   Post reply


Forum Jump:
Rate This Thread:
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF.
 

ExamNotes forum archive


Powered by: vBulletin 2.2.8
Copyright ©2000, Jelsoft Enterprises Limited.

  Free Braindumps | mcse braindumps