SSIS flat file manager - skips the last record I've a a flat file which is pipe delimited as shown below:

header|header2
abc|abcdef
abc|abcdef


When I create a package on a 64 bit machine it always drops the last record. But on preview it shows both records.

Update:

If I do this it works:

header|header2
    abc|abcdef
    abc|abcdef
       |


Why is this and how do I fix it?
I had the same problem on Windows Server 2008 R2 x64.  A flat file source would not load the last record... So this answer helped me, and now it's working fine.


  Go to advanced column view, select all the columns and set the text qualification drop down to false for all the columns.