Justin,

"OLE DB Source" can only connect to a one server at a time.

The Foreach Loop container is used to retrive the server values from the variable SQL_RS.

The server name is passed one at a time to the "OLE DB Source" task in the variable SQL_Conn.

Once the Data Flow Task "Load Database Status" finishes it's two tasks, the For Each Loop passes the next server value from SQL_RS and to "OLE DB Source".