====== 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:differences|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 [[.:sprockit:differences|host of other benefits]].

<WRAP group>
<WRAP 40% column>
===== Get started =====

<WRAP round download 80% >[[.:sprockit:download|Download Sprockit]]</WRAP>

  * [[.:sprockit:introduction|Learn about Sprockit]]
  * [[.:sprockit:differences|Find out what makes Sprockit different]]
  * [[.:sprockit:tutorial|Try the tutorial]]

</WRAP>

<WRAP half column>
===== More information =====

  * [[sprockit:dd:sprockit_tables:sprockit_tables|Sprockit tables and views]] (interactive database diagram)
  * [[.:sprockit:configuring_processes]]
  * [[.:sprockit:restart_and_rewind]]
  * [[.:sprockit:process_lineage|Process lineage tracking]]
  * [[.:sprockit:pipeline_visualisation|Pipeline visualisation]]
  * [[.:sprockit:index_maintenance|Index maintenance]]
  * [[.:sprockit:custom_logging|Custom logging]]
  * [[.:sprockit:utilities]]
  * [[sprockit:faq|FAQs]]

  * Slides from my //{{.:etl_metadata.pptx|Metadata-first ETL process control}}// talk ([[https://sqlbits.com/|SQLBits]], March 2nd 2019).
</WRAP>
</WRAP>


Sprockit is Copyright © 2015-2019  [[richard@RichardSwinbank.net|Richard Swinbank]] and licensed under [[https://opensource.org/licenses/MIT|The MIT License]].

{{tag> sprockit etl tsql}}