Well now. This is great stuff.

My goal certainly was to allow readers of my original article to modify, extend, enhance and utilize the SSIS package I had put together to collect information about the entire SQL infrastructure. I did not realize the exuberance might lead to reader's own articles based so closely on the original solution.

Glad to see it and this would be my first bibliographical reference in my DBA and writing career for SQL Server.

Of course, I would be remiss if I did not mention that my own enhancements to the solution, both SSIS and SSRS are combined in a follow up article in February 2008 SQL Server Magazine. In the article I cover numerous additions to my original SSIS solution, whose assumed name is now "SQL Snapper" for snapshot SQL Server data gathering and reporting. Sounds a little better than repositories and packages. The enhancements include my own version of disk space monitoring (without the requirement for OLE Automation), security reporting at many levels, and job schedule support for SQL 2000 and 2005. I also expand on connectivity to environments that require SQL authentication and provide many new reports that I use quotidianly.

Rodney Landrum

Author "Pro SQL Server 2005 Reporting Services" (Apress)