The following six-part series serves as an introduction to BIML by way of solving the problem of migrating data between two databases with the same schema.

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


One thought on “BIML

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s