after you have chosen your datasource as flat file,
go into the Advanced tab which will be highlighting the 1st field and saying OutputColumnWidth 50.
hold down SHIFT and click on the last field in the list - so you highlight All fields.
Change the OutputColumnWidth to 500 or some other value you need...
This stops most fields throwing data overflow / truncation.