Conversion Transformation from DT_TEXT to DT_NTEXT is not working

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



1 comment

Please sign in to leave a comment.