we can achieve the same output without adding the rows Cluse

SELECT

CustomerID

, SalesOrderID

...

I had the same problem

I figured it out

I created the variable at Ftp task level create it at Package level and the files started downloading