1st of all i totally agreed with Phil.

but most of the time ... they say ... there is no issue in it 😛

here are couple of things you can try thou:

1. Check that csv if its ending line 'CR' or 'LF'. (you can check it NotePad++)

because, there might be a case try to adjust your row identifier, you can also check this file while to import its using MS Access as well. check if the same issue happens or not.

if you are using flat file connection.

2. you can parse the file in script manager, in that you can avoid it when you split the string and you can also log these error lines in a file or any tables as well.