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?!

  • July 21, 2011 at 2:36 pm

    #1356747

    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

    Things will work out.  Get back up, change some parameters and recode.