I noticed that my table definition for the [Business_Unit_Flattened] table was not quite right (some columns that should have been nullable were not) so I cleaned it up. Apologies for any confusion.