Sprockit is a lightweight but powerful ETL process controller for managing SSIS package and T-SQL stored procedure execution. It's free, open-source and written purely in T-SQL.
sprockitviz uses Sprockit's dependency information to generate browseable, click-to-explore visualisations of Sprockit-managed ETL pipelines. e.g. (just a screenshot, you can't explore this one!):
