DT_(N)TEXT is a CLOB format. In order to convert it to a regular string, you need to use a script component.
Google for ssis script component convert blob to string and you will surely find some examples.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP