Have you thought of using SSIS and the RS scripting utility?

I developed a solution using that technique to render PDF versions of a specific report once per month.

Do some Googling for Rs.exe or Rs Utility and you'll find the scripting language is quite powerful.

Should be able to accommodate what you need.

Good luck!