• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1545
  • Last Modified:

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

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
yrcdba7
Asked:
yrcdba7
1 Solution
 
k_murli_krishnaCommented:
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
 
yrcdba7Author Commented:
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
 
Nathan RileyFounderCommented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
k_murli_krishnaCommented:
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
 
yrcdba7Author Commented:
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
 
Anthony PerkinsCommented:
Please post a valid sample where we can duplicate the problem.  The line you posted is valid.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now