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

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

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
M_Boy76
Asked:
M_Boy76
  • 7
  • 6
  • 2
1 Solution
 
PedroCGDCommented:
dera friend,
attach here the flatfile to try to help! and the ssis package. (rename files to txt)
regards
0
 
M_Boy76Author Commented:
Sorry cant attach the file as it contains sensitive data:
0
 
PedroCGDCommented:
I understand... but this way is difficult to help... could you attch the file only with 5 rows to check?
regards
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
jorge_torizCommented:
What is your column delimiter?
0
 
M_Boy76Author Commented:
column delimite is {CR}{LF}
0
 
PedroCGDCommented:
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
 
PedroCGDCommented:
or...
send me the first 4 or 5 rows of your file to try to resolve it!
Regards
0
 
jorge_torizCommented:
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
 
M_Boy76Author Commented:
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
 
PedroCGDCommented:
dear Friend,
With these 4 rows you have errors?
I tried and it works perfectly!

EE-Email.JPG
0
 
M_Boy76Author Commented:
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
 
M_Boy76Author Commented:
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
 
M_Boy76Author Commented:
Fixed it - had to convert the file to an excel spreadsheet and import it, which worked fine with ease
0
 
PedroCGDCommented:
Do you still need helP?
regards
0
 
M_Boy76Author Commented:
No,not at all, but thanks for your contribution...
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 7
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now