looking at the error, it's not picking up the servername correctly, so check the source table column names and inparticular look at step 6 again..
Step 6 - Building The Server Query Loop
Now we have server to query, we can build the loop to iterate through the server list.
Add a For each Loop Container to the data flow work area and name it FELC Server Query. Double-Click the For Each Loop Container and select Collection. On the Collection form,
•set the ADO Object Source Variable to User::ServerList.
•Select the Enumeration mode to Rows in the first table
•Under Variable mappings, map the Variable User::ServerConnString to index 0.
make sure you are mapping the variable User::ServerConnString
to an index value of 0
MCITP: Business Intelligence Developer (2005)