I ended up developing a framework for the SQL Server system that I develop and manage. I just happened to observe patterns in the processes I was developing and built the framework as the means to performing them. I didn't set out to do this at first; the main impetus was that I don't like repeating code. (Repeated code is a big problem in a system that I inherited when I took my job.) My solution works basically on a workflow motive. At this point it is implemented entirely in T-SQL; I'm looking into SMO and CLR code for future development. I would consider SSIS, but I develop and do source-control in Visual Studio 2010, and SSIS isn't integrated into Visual Studio 2010.