This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There are a lot of options I’m not going to go into here due to lack of time. If someone expresses interest I’ll try to do a more detailed post later.
At this point when you run your Foreach Loop Container each loop it makes will cause the Connection Manager ConnMan1 to point to a different server.
I realize this was rather fast, and I would have loved to have shown some sample output. Unfortunately as I stated at the beginning I’m rather pressed for time today and want to get this out quickly to answer a post.