This can happen if the last column of the last row in your csv file does not have whatever you used as a row terminator. In your case 0x0a For example ColumnA,ColumnB0x0a (Header column) Value1,Value_20x0a Value3,Value40x0a Value5,Value6

In this case SQL will not load the row that contains Value5 and Value6.