Hi,

Today I tried a looping as following:

My job has two tasks, 1st is an sql query, 2nd is a file write task.

1st task : SQL query task

---

Returns multiple rows with a comma as column delimiter and text qualifier is ".

2nd task : file write task

---

Append to current file and write the output of the 'previous' task


If I make this 2nd task a looping task with the 'for each x in y' and let it use the output of the 1st task and change nothing else, the job will not stop running. Both tasks will run only one time. Strange because the 2nd task has to run for every line of the output of task 1.

I tried to set it up that the looping task writes only a line from task 1 and adds some extra text, but also I do not get this to work.

Am I making a mistake here?

Regards
Erik

---

Hi,

Today I tried a looping as following:

My job has two tasks, 1st is an sql query, 2nd is a file write task.

1st task : SQL query task

---

Returns multiple rows with a comma as column delimiter and text qualifier is ".

2nd task : file write task

---

Append to current file and write the output of the 'previous' task


If I make this 2nd task a looping task with the 'for each x in y' and let it use the output of the 1st task and change nothing else, the job will not stop running. Both tasks will run only one time. Strange because the 2nd task has to run for every line of the output of task 1.

I tried to set it up that the looping task writes only a line from task 1 and adds some extra text, but also I do not get this to work.

Am I making a mistake here?

Regards
Erik

Please upgrade to 6.0.3 first to see if the "Job will not stop running" disappears.

---

Ok, I will (see pm)

Regards,
Erik

---

Hi,

Seems to be solved in 6.0.3
Thanks.


Regards,
Erik

---

Great, thanks for the update.

---