SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.
SSIS: Archive or Copy Files using dynamically specifying FileSpec file types for File Enumerator in Foreach loop
In SSIS how to continue a for each loop container even if its inner tasks fails (Usage of Propogate Property in SSIS)