Data Underflow in Unstructured CSV

Dec 13, 2010 at 12:41 AM

Hello

Firstly, I am very new at SSIS so please excuse me if this is a silly question.

I have an issue reading an unstructured CSV. Below is an example of the data:

"00001","236563","TEXT","TEXT",12323.00,"TEXT"
"00002","356603","TEXT"
"00003","356603","TEXT"
"00004","236563","TEXT","TEXT",12323.00,"TEXT"

When I add a text file containing this data as the DFS source,  previews all look promising... the data in the grid looks how I would expect it. However when I pass it on, lines 2 and 3 error with the following message:

2,70033,2010-12-13 11:35:44.059000000,Column 4,DT_STR,255,Truncation (underflow) - the number of columns provided was less than expected.,

Is there any way I can pass through these rows?

Thankyou

Shaun