Thank you for this post, it helped me understand how the for each loop container writes into a variable , which is then subsequently used in the connection manager.