(r.stropek) 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.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help