Home Forums SQL Server 2005 SQL Server 2005 Integration Services multiple datasources/servers? RE: multiple datasources/servers?
Ant-Green
SSC Guru
Points: 113445
More actions
August 14, 2012 at 6:53 am
#1525479
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.