Vision Binary

This is a variation of a pattern I saw in SQL Server Integration Services Problem Design Solution by Erik Veerman, Jessica Moss, Brian Knight, and Jay Hackney.  I would highly recommend this book.  I found at least 4 chapters in the book that were each worth the price of the book.  It is full of good and practical ideas for the SSIS developer.

In an ideal ETL all your data would load at the right time, your dimensions would come first so that by the time you got to your fact load all the lookups found the right member in the dimension, pulled the proper reference key and proceeded.  Unfortunately we don’t all live in that world so we have to worry about missing dimensional data during our fact load.  There are a lot of reasons why this can happen and this is one approach to solving this issue.

When…