Columns are not loading properly from Flat File (Pipe Delimiter)
I have a Flat File (Pipe Delimiter) contains 28 Columns.
Input File contains 200000 Records. All records loaded properly except one record.
For that record, first 6 columns are not loaded. 7th column from Flat file started populating into 1st Column in Template Table (Target Table) and So On.
1) For Previous record, Last 6 columns are NULLs.
2) If I load this one record Individually, its being loaded correctly
Could you please let me know how to load this row properly along with huge file.