I have a package that collects information from an SQL Server about the databases on that server. I store this information in a table from where I can create graphs (for example the disk usage, etc.). Now I would like to run this package for about 20 servers.
The only difference in the package is the connection of the source DB. What would be the easiest way to do this:
1. Build a loop in the package that runs 20 times and putting the server name in a variable
2. Set package configurations that it runs 20 times with every time a different value for the server of the read db component (is that even possible??)
3. Another option that I don't know of yet?
View Complete Post