MMOAP
Gather data about your SQL servers using DTSX with easy custom SQL!
MMOAP is the result of many MANY years spent in numerous IT environments and not having enough information on hand to make rational decisions. MMOAP is essentially a data gathering tool, specifically geared towards DBA's who need to interrogate SQL servers, and then store the results in a central repository, and then raises alerts on conditions of interest.
MMOAP is like many commercial tools (SCOM, Idera, Spotlight, etc.) except MUCH simpler, and also like many homegrown solutions except much more robust. Once MMOAP is setup, you never have to modify the dtsx package. Commands and Alerts are dynamic, driven by SQL that is stored in tables that you can change any time.