Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB. In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB. I transferred it to my local folder & when I opened it, I got to see only 1,046,574 records & the rest weren't there. I tried exporting a couple of times compressing the file but nothing helped me. I couldn't figure out the solution. Can someone help me understand why this is happening? Is there a size restriction for export? What steps I need to take to export all of the records?
Thanks in advance!