• 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