Is there a record limitation with flat file with a csv extension?
I have migrated a flat file load in BI 7.0 and now it seems there is a record limitation of 65k rows in the file. I am getting the following error mesage in the monitor: option =2. CSV split errorr: 2 =other problem with the escape character.
If I use a file with less than 65K rows ( and I mean 1 less than ) I get no error and if I use a file with more than 65K ( and I mean 1 more ) I get the error. Is there a setting somewhere that is setting the load limit to 65K or is this a real limitation?
Some more thing you can try.
Try to reduce the Inpackage Packet Size.
If all these things are not working then we have to split the file and load it. Espescially with BI 7.0 I have also faced this problem and finally I split the file and loaded the data.