Excellent Question and thorough explanation.

Thanks!

I'm partial to Marvel's 'The Beast' myself. There's a bit of comedy to such an urbane persona lurking within that hulking frame.

@BrnBgls - It's from one of my least favorite...

I had the same problem and discovered that changing the datatype in a derived column from unicode text stream (DT_NTEXT) to Unicode String (DT_WSTR) cleared up my problem.