Solved

invalid delimited data: text qualifier must be followed by a column delimiter

Posted on 2009-04-10
6
1,360 Views
Last Modified: 2013-11-30
I have the same problem to import data by DTS, I clicked Delimited, file type: ANSI
row delimiter {CR}{LF} and text qualifieer Double Quote{"}, but I got this error
here is my .txt file
"2233","1","18-SEP-00","3","08-SEP-00","9","2000","647","1","1"
0
Comment
Question by:yrcdba7
6 Comments
 
LVL 17

Expert Comment

by:k_murli_krishna
ID: 24117274
I think, text qualifier " is only for text i.e. CHAR, VARCHAR etc. data. For date/datetime, it should be single quotes, for integer/decimal there should be no quotes in the .csv data file. You need to prepare/generate/export .csv file using better method/technique/tool.
0
 

Author Comment

by:yrcdba7
ID: 24117319
the file is with datetime, integer/decimal all of data is " ", I can not change them, it is 100K records.  what tool you prefer?
0
 
LVL 11

Expert Comment

by:N R
ID: 24117452
I had this problem I I just changed the file to tab delimited and it worked.  Do you have the ability to change what type of delimited columns you will be getting in the file?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 17

Accepted Solution

by:
k_murli_krishna earned 500 total points
ID: 24117559
Sorry, I do not think that is the problem. Are you mapping data to columns correctly? Also, without the double quotes ("), is the data's data type matching the column's data type? This is just a weather warning rather than a forecast ::)).
0
 

Author Comment

by:yrcdba7
ID: 24117672
I frist try to give all cols varchar (255), so I can import data into table then change data type. right now it stop to input data to table. it complain invalid delimited.  I look at text file, I don't see where I can change delimited to tab data type for .txt file.

I clicked Delimited and
file type: ANSI
Row delimiter:  {CR}{LF}
Text qualifier: Double Quote{"}

I used emediter delete .txt ending line space, then copy data to .txt file to import data. the delimiter gone maybe because I use editer to delete space, it taked delimiter out.   well still no work.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24124018
Please post a valid sample where we can duplicate the problem.  The line you posted is valid.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Can I legally transfer my OEM version of Windows to another PC?  (AKA - Can I put a new systemboard in my OEM PC?) Few of us are both IT and legal experts but we all have our own views of Microsoft's licensing rules and how they apply.  There are…
Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now