Cathrine Wilhelmsen shows how to use tiered Biml files to prevent repetition:
Many Biml solutions start very simple, with just a single Biml file that generates a few SSIS packages. Most developers quickly see the need for a more complex solution for multiple sources. One way to reuse code and apply the Don’t Repeat Yourself software engineering principle in Biml is to use Tiered Biml Files.
In addition to using Tiered Biml Files, there are four other main ways you can avoid repeating your Biml code:
- Include Files
- CallBimlScript with Parameters
- C#/VB Code Files
- Transformers (BimlStudio feature only)
In this post we will look at how to use Tiered Biml Files.
Tiering is a helpful mechanism for doing work in one location and using the subsequent results of that work within your Biml solution. Read the whole thing.