Chapter 10: Manage SSIS and Azure Data Factory with Biml

Many developers will agree, I think, that one of the hardest things to bear at work is not solving complex problems or rushing to meet a deadline, but the boredom. The boredom of uninspiring tasks, the lack of an intellectual challenge, and repeating the same code, the same logic, and the same field names over and over. Let's take developing SSIS packages as an example: many SSIS development tasks may seem repetitive and boring because the same patterns apply to multiple packages, and we just change table names and the set of columns from package to package.

This is why I am thrilled to introduce Biml in this book! Biml stands for Business Intelligence Markup Language, and it does what I've always wished for – it generates SSIS packages based on the pattern that you design.

What's more, Biml can generate anything based on a given pattern: T-SQL, text, JSON, tabular models, Azure Data Factory, PowerShell...