Hello,

I have a job which is using the loop feature. The loop task is running a SQL command, and within the command I'm using the {LOOP(CurrentValueX)} variable to run the command against a list of databases in the loop. The command works fine and iterates through each value in the loop/list, but when I look at the output in the Task Log for each iteration of the loop/list, they all contain the just the 1st value in the loop/list. Is this by design or should the output from each task iteration in the loop contain the current value for that iteration?

Thanks for your help.

It depends on a couple of things:

1. what is the source value in the for each loop? And have you loaded the source outside the loop?
2. perhaps the wrong newline character is used - how is your data separated?

---