If your CSV file has missing lines, this is usually caused by data being returned out of order.
The task is processing rows in the wrong order, creating a new CSV file for each unique key value (such as an order number) and overwriting it when that key appears again later. To fix this, sort the data by the key field — this ensures all lines for the same key are written to the file before the task moves on to the next.