Home Forums Reporting Services Reporting Services How to collect data from multiple servers to a single table to generate report? RE: How to collect data from multiple servers to a single table to generate report?

  • April 10, 2014 at 1:54 am

    #1704770

    Sarwan (4/9/2014)

    I have query which populates a table.

    I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that I can pull reports from that single table?

    Could you advice me the best approach for this?

    The easiest way to implement this - in my opinion - is to build a small ETL process with SSIS that gathers the data from all the servers and stores it in a single server. That way you won't have to use linked servers.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP