A six-part series on test automation for Azure Data Factory pipelines. Automated testing is a key component of CI/CD development pipelines: it allows you to run more tests, more often, more quickly, with guaranteed repeatability. In the series I build up an approach to writing tests for ADF and triggering them automatically.

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. You can download it here.