I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source:
- SSIS Framework Community Edition – free, open-source, and SSIS Catalog-integrated
- Framework Browser – free
- SSIS Framework Commercial and Enterprise Editions – for sale (please see edition feature comparisons)
- Catalog Reports – free, open-source. I love the SSIS Catalog reports that ship with SSMS. I hate that they’re hard-coded into SSMS. This is an SSRS solution.
- Basic SSIS Catalog Dashboard in Power BI – free, open-source
- BimlExpress Metadata Framework – free, open-source
- SSIS Catalog Browser – free
- SSIS Catalog Compare – for sale and a new version is in Preview. You can see the Preview version in action in the free webinar recording Use SSIS Catalog Compare to Lift and Shift SSIS to ADF (registration required)
I recorded a series of free webinars about Azure Data Factory (ADF), Azure Data Factory Integration Runtime (ADF IR), and ADF Design Patterns:
- Use SSIS Catalog Compare to Lift and Shift SSIS to ADF
- Designing a Custom ADF SSIS Execution Framework
- ADF Controller Design Pattern with the SSIS Integration Runtime
- The Azure Data Factory Controller Design Pattern
I’ve recently updated two training sites:
:{>