I'm reading from a data source that returns unicode strings, and the output goes into a data conversion transform where I output a "string [DT_STR]" from it as my database is using varchar and not nvarchar.
The source is outputting a string with an en dash in it, but after the conversion, my database ends up with – in place of the en dash.
I know a varchar can contain an en dash character directly. What's the proper way to handle this conversion without losing that en dash?