SSIS Database copying

[imnotso]

Hi, I have a master DB server, I need to update 4 more DB servers with data from 10 tables on the master. All tables and DB structures are the same on all servers. We need 4 because of traffic load. So.... I was thinking of setting up a SSIS .DTSX package. Easy for 1 server to another. How do I get it look at 3 more ? Configuration XML file? Can I put in 4 database names, username and passwords and get it to FORLOOP? Do i have the data in a separate table, load it into an object in the package and FORLOOP that? Or do I create 4 packages and schedule them next to each other ! That would be the easiest. Any help would be welcome. Harvey

[J4amieC]

I would go with 1 package, and configure it to run 4 times with different configurations for the destinations.

[imnotso]

The 4 different configurations can all be put in 1 XML file? Any ideas would be gladly received.