Solved

Error 0xc0202055: Data Flow Task: The column delimiter for column "e-mail" was not found.

Posted on 2008-10-01
15
3,595 Views
Last Modified: 2013-11-10
Hello I am trying to import an flatfile, with the import export wizard, and I get the following error message:

Error 0xc0202055: Data Flow Task: The column delimiter for column "e-mail" was not found.

can anyone help?
0
Comment
Question by:M_Boy76
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
  • 2
15 Comments
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22616896
dera friend,
attach here the flatfile to try to help! and the ssis package. (rename files to txt)
regards
0
 

Author Comment

by:M_Boy76
ID: 22617039
Sorry cant attach the file as it contains sensitive data:
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22617060
I understand... but this way is difficult to help... could you attch the file only with 5 rows to check?
regards
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22618168
What is your column delimiter?
0
 

Author Comment

by:M_Boy76
ID: 22621955
column delimite is {CR}{LF}
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22623214
Dear Friend M_Boy76,
Take a look to this post:
http://agilebi.com/cs/blogs/jwelch/archive/2007/05/07/handling-flat-files-with-varying-numbers-of-columns.aspx

Try to apply the same logic
Regards
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22623221
or...
send me the first 4 or 5 rows of your file to try to resolve it!
Regards
0
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22624647
Well, there must be a line in your file that do not have the {cr}{lf} delimiter in your columns.

Its important to say that its very weird to use that as a column delimiter, that combination is commonly used as a row delimiter... verify your settings.

Give us your column and your row delimiters
0
 

Author Comment

by:M_Boy76
ID: 22626481
Alright Guys

I have added the 1st 5 records of the CSV file, for you to figure out what is wrong with the importation to SQL Server, the 1st line are the column names....
Sample.txt
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22626835
dear Friend,
With these 4 rows you have errors?
I tried and it works perfectly!

EE-Email.JPG
0
 

Author Comment

by:M_Boy76
ID: 22631876
Hello

I see from the screenshot you sent that you used the UNION ALL task, and apart from that, in the e-mail column you have 0, just before the email address.

Also the " symbol is appearing in records which needs to eliminated.
0
 

Author Comment

by:M_Boy76
ID: 22631965
And I keep getting the following erorr message:

Error 0xc0202055: Data Flow Task: The column delimiter for column "e-mail" was not found.
 (SQL Server Import and Export Wizard)
 
0
 

Accepted Solution

by:
M_Boy76 earned 0 total points
ID: 22634624
Fixed it - had to convert the file to an excel spreadsheet and import it, which worked fine with ease
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22635998
Do you still need helP?
regards
0
 

Author Comment

by:M_Boy76
ID: 22639928
No,not at all, but thanks for your contribution...
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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