Hi, I am trying to convert all nonUnicode columns to Unicode. It works for all varchar columns but it does not work for big data types like DT_TEXT. foreach (var column in table.Columns.Where(c => c.GetTag("CONVERT_TO_UNICODE") == "Y") ) { } There was a row created for column of DTTEXT datatype in the conversion transformation object but no conversion was applied. I have to change it manually from DT_TEXT do DT_NTEXT (Unicode Text Stream) I tried to use override (SsisDataTypeOverride="DT_NTEXT") but it does not work either. DT_TEXT to DT_NTEXT example