Output to .CSV file with field type VW_String

[huhog55]

I am trying to read in an Excel file and output it to a .CSV file. I need the output field types to all be VW_String to match another schema from a different system that I don't have control over.

I have the select tool set to VW_String in the flow, however, when the file is created the schema is always V_String.

Is VW_String not available as an field type option for .CSV files?

I also looked at the XML configuration and it is exactly the same. Is there some other way to configure this output or is this a limitation of the output tool in Designer?

[huhog55 · Accepted solution]

I think I solved it...

Changed the "Code Page" setting to: "Unicode UTF-16" and it seems to work.

I will leave this up in case it helps someone else...thanks!