LoggingMode.UseParentSetting is a good idea, but... beware the connection string!

Because logging starts before configurations are loaded (classic chicken-egg thing, we went with chicken apparently), if you're trying to set your connection string from a parent package variable, this no workie for logging. Doh! While I wish I were smart enough to have figured this out for myself from the pieces of the puzzle that I already possessed, but I have to credit DMauri's excellent blog for saving what little hair I have left. It's still possible to code semi-circular references, even in SSIS... (I guess this is more of a sequencing problem, but I like semi-circularness. It sounds more geometric.) Also note that it only applies to immediate child packages. If you've got a deep hierarchy of child packages (deep == more than two levels), UseParentSetting doesn't appear to be very transitive. (Grrr!) Caveat developer.