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 12:40 pm

    #1356667

    Ah yes, create an OLE DB Source in the Connection Manager as well.

    You will dynamically set the connection properties.

    You may find this article useful.

    http://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/

    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/