SQL Server SSIS Derived Column Transformation changing data type to Unicode | BI Monkey
@Todd, as per Paul’s comment – test for yourself – if you create a Derived Column, give it a value and set the Data Type to Non-Unicode, if you then change that value, the component forcibly changes the data type to Unicode. This is the thing that annoys ...