Sounds like your connecting to the same server.
1) Check the MultiServer Connect and verify its propery setting expresssions is ServerName @[User::SRV_Conn]
2) Now check Populate ADO Variable properties.
The Result Set should be
Result Name 0
Variable Name User::SQL_RS
This variable was my default value. I should of documented that it should be selected.
3) Run this query to confirm the server names in the table
SELECT RTRIM(Server) AS servername
FROM SSIS_ServerList
WHERE (Skip_SQL_Overview is null or Skip_SQL_Overview = 'FALSE')
ORDER BY 1
Let me know how it goes
David Bird