You need your execute SQL task to use the connection manager that you've setup to use the dynamic server name from the foreach loop variable. Here's a link that shows a decent example of the technique.
http://www.sanssql.com/2011/08/looping-through-sql-servers-using-ssis.html