Posted Fri, 21 Sep 2018 21:59:49 GMT by

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

Posted Sat, 11 May 2019 03:49:28 GMT by jacob alley

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.

You must be signed in to post in this forum.