Hi,

This is a great idea and I've just done something similar, but more focused on producing server documentation of jobs, backup devices etc etc.

What I'd like to suggest is a slightly different alternative to acheive the same result.

I would create an SSRS report with a data source for each of your severs.

Create a report a separate report for each server to view the job history of jobs on the server.

Then using SSRS create a report which includes a sub report, point to each of the server reports.

This would remove the need for SSIS and storing data in SQL (unless of course you need a bigger than you keep for your job history..