[4.9.40] SQL Task Variables to write file - VisualCron - Forum

Community forum

darrrius
2010-11-09T23:26:51Z
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
Support
2010-11-10T08:23:17Z
There might be a limit in version 4. But there is no limit in version 5.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
darrrius
2011-11-17T02:47:33Z
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.
Support
2011-11-18T14:05:11Z
Could you give an example what you mean with "incorrect order"?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top