Text was truncated or one or more characters had no match in the target code page - from SQL Server

Question

I am trying to read a stored procedure and then output that to a flat file in SSIS.

and to the flat file

It is erroring on the field 'Name' and the file output stops before

'Men[']s Fairisle Jumper - L'

Any help appreciated. The apostrophe seems a strange character

Answer 1

Resolved the issue by making it

Unicode string [DT_WSTR]