I am pleased to share Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework is now live at SQL Server Central!
Typing that, I realize I neglected to publicize the fact that two other Stairway to Biml articles were recently published at SQL Server Central:
- Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework
- Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages
These three articles are taken from two chapters in The Biml Book:
- Chapter 6: A Custom Biml Framework
- Chapter 7: Using Biml as an SSIS Design Patterns Engine
Level 7 is focused on collecting and storing database metadata that will be used by Biml to automatically generate SSIS packages for a data integration solution.
Level 8 centers on one method for using the collected metadata to build a simple Biml-driven framework that automatically generates the SSIS packages for such a solution.
Level 9 describes and demonstrates one way to refactor this simple Biml framework, decoupling design patterns that were hard-coded in previous examples.