The BIML series is now at a conclusion. Here’s a wrap-up of what we did:
BIML
Part 1 – Introduction
Part 2 – The Problem We’re Trying To Solve
Part 3 – The “Ideal” Package
Part 4 – Implementing The “Ideal” Package
Part 5 – Expanding To Multiple Tables
Part 6 – Lookups
In addition to this six-part series, we also covered a few side issues of interest:
Deleting Data In Batches
Generating An Empty Node
Tracing Foreign Key Dependencies
BIDS Helper Bug With NoMatch In Visual Studio 2013
IF Statements In Task Sections
This post will also live on as a separate page for posterity’s sake.