Home Forums SQL Server 2008 SQL Server 2008 - General SSIS - Run a query for multiple servers and stored resultset in local database/table?! RE: SSIS - Run a query for multiple servers and stored resultset in local database/table?!

  • WebTechie38 (7/21/2011)


    Putting the query in the OLE DB source worked well.

    That did it! Task complete.

    I can now run this on all production servers and keep the results a monitoring database.

    Thanks for all your help. I can now use this knowledge in quite a lot of upcoming projects.

    Thanks again,

    Tony

    I'm glad that the members on this forum were able to assist you.

    Your are in the processing of developing an arsenal of SSIS Projects.

    Check them into Source Control and save them on your own media.

    Once you get in the grove you will be on a roll. 😎

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/