I had a "near real time" dashboard that was grabbing data every ten seconds. Now that was insane! 😀

I'd agree with the earlier posts about just doing the work inside T-SQL; grab SSIS if you need it, but the chances are it's just going to be an added complication without adding any value.

Also, from a design perspective, try to isolate "tactical reporting" (immediate to short term) from "strategic reporting". This means you may decide to go with a layered approach and produce a relational data store for the tactical reporting, with a data mart for the strategic reporting. Doing that can save you from a lot of heartache in the future!