The copies of the main databases are for reporting purposes. The main dbs are under quite a bit of realtime load so the vendor recommends offloading the data to the dupes. Sometimes if the Mains, which should contain the same data, go down or have a network outage the data isn't the same across the board.

Dupes 1, 2 = Main 1

Dupes 2, 3 = Main 2

I think if I was allowed to run the SSIS on the Main DBs that it would work out perfectly, the required validation piece of it and the fact that it has to run off of one of the Dupes is what confuses me on how the SSIS would work out.

Is it possible to do the validation piece with SSIS?