Our Flat File Manager from csv file had import error due to unexpected LF in some columns, even though with file delimiter CRLF. The csv file was transfered from other Windows system with same code page (SJIS, 932) but that file was originally exported by Linux System.
Could you kindly let me know how to ignore LF as delimiter or just remove LF from big file in SSIS?
Any advice would be appreciaed again.