Search code examples
sql-serverssisssis-2017

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

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

enter image description here

and to the flat file

enter image description here

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

Solution

  • Resolved the issue by making it

    Unicode string [DT_WSTR]