BIML, Part 1 — The Introduction

I like SQL Server Integration Services a lot. It abuses me far too often with unclear error messages, finicky metadata requirements, and maddening inconsistency, but when it works, drag-and-drop ETL is a thing of beauty. One thing which drag-and-drop ETL does not do well, however, is scale. When I'm working on a single package, bringing…