New project and moving on to SSIS. As I learn the new “nuances” of another ETL tool, one quickly learns its shortcomings. A standard staple: dynamic lookups seems to be missing. Supporting Info Here
Guess I’ll have to conjure up a solution. I’ll post the developed solution, if I find one.