Hi,I have an input text file which contains line(s) which can have more than 8000 characters. I am able to read the lines in this file by specifying that the input column is data type = Text Stream [DT_TEXT] and I can then write the lines to another text file.But, what I want to do is to use only the right-most 8000 characters. When I try to convert the input column to data type = String [DT_STR] using the Data Conversion transformation then I get the error:- The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.I cannot use the string manipulation functions e.g. RIGHT or SUBSTRING in a Derived Column transformation because these functions do not work with DT_TEXT data. Any Ideas?!Thanks.
View Complete Post