Sprockit
Sprockit is a powerful but lightweight ETL process controller for managing SSIS package and T-SQL stored procedure execution. It's free, open-source and written purely in T-SQL.
The difference between good ETL process control frameworks and great ones is how they perform when things go wrong. Desirable behaviours – like fault tolerance, quick fault finding and easy resume after error – often aren't available and sometimes seem hard to achieve.
Sprockit is different – it provides all this using only T-SQL and the SQL Server Agent, while at the same time supporting parallel processing, adapting to evolving workloads, providing a breadth of monitoring and diagnostic information and a host of other benefits.
Get started
More information
- Sprockit tables and views (interactive database diagram)
- Slides from my Metadata-first ETL process control talk (SQLBits, March 2nd 2019).
Sprockit is Copyright © 2015-2019 Richard Swinbank and licensed under The MIT License.