Solved

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

Posted on 2008-10-01
15
3,387 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
  • 7
  • 6
  • 2
15 Comments
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
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
Comment Utility
Sorry cant attach the file as it contains sensitive data:
0
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
I understand... but this way is difficult to help... could you attch the file only with 5 rows to check?
regards
0
 
LVL 15

Expert Comment

by:jorge_toriz
Comment Utility
What is your column delimiter?
0
 

Author Comment

by:M_Boy76
Comment Utility
column delimite is {CR}{LF}
0
 
LVL 22

Expert Comment

by:PedroCGD
Comment Utility
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
Comment Utility
or...
send me the first 4 or 5 rows of your file to try to resolve it!
Regards
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 15

Expert Comment

by:jorge_toriz
Comment Utility
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
Comment Utility
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
Comment Utility
dear Friend,
With these 4 rows you have errors?
I tried and it works perfectly!

EE-Email.JPG
0
 

Author Comment

by:M_Boy76
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Do you still need helP?
regards
0
 

Author Comment

by:M_Boy76
Comment Utility
No,not at all, but thanks for your contribution...
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

763 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

10 Experts available now in Live!

Get 1:1 Help Now