Business Service SQL results in only 1 file instead of each row in a file

Hello all,

I have a Business Service which retrieves data via a SQL adapter and writes the data in text file. My production is doing the job, but instead of the Business Operation output being one file, I am getting many files, with 1 , 2 or 3 rows only. 

Any help is appreciated. 

Thank you