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?
M_Boy76Asked:
Who is Participating?
 
M_Boy76Author Commented:
Fixed it - had to convert the file to an excel spreadsheet and import it, which worked fine with ease
0
 
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
PedroCGDCommented:
I understand... but this way is difficult to help... could you attch the file only with 5 rows to check?
regards
0
 
jorge_torizResearch & Development ManagerCommented:
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_torizResearch & Development ManagerCommented:
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
 
PedroCGDCommented:
Do you still need helP?
regards
0
 
M_Boy76Author Commented:
No,not at all, but thanks for your contribution...
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.

All Courses

From novice to tech pro — start learning today.