Conversion Transformation from DT_TEXT to DT_NTEXT is not working
Milan Hricko
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
Comments
Hello Milan, Thank you for bringing this to our attention. Would you mind creating a BimlPit issue here: https://github.com/varigence/BimlPit/issues ? That way you can subscribe for updates as we figure this issue out. In the mean time I found a possible work around here: https://stackoverflow.com/questions/31662123/the-data-type-is-dt-ntext-which-is-not-supported-with-ansi-files. I am not sure if this is practical in your situation but I figured it may help.
Please sign in to leave a comment.