I have a package that writes data into a flat file from a table. A field has data type (Unicode text stream[DT_Ntext]) which I am converting it using a conversion transformation to Text Stream[DT_TEXT]. But when I execute the package, it throws an error truncation occurred. Please suggest me how can I resolve this issue. Thanks, Ramya
As @Cyborg mentioned here, Check the Unicode Characters. But if you have Unicode characters and and need to store them as non Unicode, then you need to have correctly set the system Non Unicode Programs (system locale) set. If you have the system locale set to English, and will want to store character which is not contained in the English ANSI character set, then it will fail. But if you change the system locale to appropriate language, then you should be able to store Unicode characters specific to that language using ANSI char set.