Collect results of many sql server jobs
I've created an SSIS package that connects to multiple servers and runs a query and copies that data to a central SQL server that I report against.   Just took a while to get the query to contain all the information I needed but the SSIS package is pretty straight forward, so may be an easier option than txt/xml