• You cab try using the Export Column transform. This is specifically meant for datatypes like DT_NTEXT etc.