I am using VisualCron 4.9.40 and I have a task that runs a query. I the results of the query I need to put into a flat file. When the query runs not all the results are being displayed in the file.

Is there a limit to the amount of data that the variable holds if it is being used in one of the following steps?

Thanks

There might be a limit in version 4. But there is no limit in version 5.

---

When I have the SQL task with a stored procedure or execute an SSIS in SQL 2008 the data looks correct in the preview but when I attempt to write the file using the variable stdout for the task that run the query, the data comes out in the incorrect order. How can I ensure that my data is in the order that the select generates. I am using visualcron version 5.5.3.

Could you give an example what you mean with "incorrect order"?

---