Perhaps this might help

http://technet.microsoft.com/en-us/library/ms188386.aspx

if it can be near time, could you also not configure a SSIS package to consolidate the data into one location?