Using Biml as an SSIS Design Patterns Engine

It might not have been obvious, but your code was implementing a specific SSIS design pattern using your metadata and BimlScripts. With the same metadata and modified BimlScripts, you could implement totally different patterns with altered semantics, performance characteristics, and much more. After implementing multiple such patterns, you might even want to create a mechanism to select the desired pattern for a given transformation through the metadata itself. In fact, let’s go ahead and do that right now.