Data Underflow in Unstructured CSV

Dec 12, 2010 at 11:41 PM


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:


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?