• X amount of data flow tasks selecting what is needed from the same table in each server, then import that into 1 big central table.

    They in the report query the big central table.