You can have two jobs running simultaneously and importing to the different tables. If the data resides on different machines you would need to connect via linked server objects. So if this is something that needs high availability for reporting, you should have all your data in a master warehouse. If performance is a concern there are remedies with upgrading hardware (ram, diskspace). SSIS is quite fast though at pulling in data and I would recommend looking into it if you haven't already.