I agree with steve,

SSIS would be your best bet if you have the knowledge to use it.

Alternative if you don't have SSIS knowledge you can use a SP on the database level and SSRS as frontend witch can also be sheduled to run on certain timestamps and provide the data as needed.

Wkr,

Eddy