Run Sql on multiple databases

I need to run a same query on 15 different databases and union the results.

Does any of the experts know how to do this with good performance?

Any help is appreciated.

Thanks

Come on over to the SSIS forum and we'll be glad to help you out with this.|||

What are you trying to do? You may get adequate performance just by executing the query:

select column1, column2
from database1.schema.table
union all
select column1, column2
from database2.schema.table
...

union all
select column1, column2
from databaseN.schema.table

The key is:

1. RAM - enough to work with the set in memory, if possible
2. Query plans - one slow query will run much slower than 15 fast ones (I just built a 26 query join on 15 million rows that runs in < 1 second.))