How to get query result in .CSV file with UTF-8 format.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  November 12, 2011 at 5:36 am

  #1406690

  Koen Verbeeck (11/12/2011)

  ---

  If you set the flat file connection manager as utf-8, it should be utf-8. So there is probably a misconfiguration somewhere.

  Check your package and make sure the resulting flat file is utf-8 or not.

  Thanks for the response. Can you please put the steps to get a varchar field in UTF-8 format.

  So that I can figure out where am doing wrong.

  Thank you.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  November 12, 2011 at 6:42 am

  #1406695

  It seems that you are not the first to come across this problem. Take a look here and see whether it might be relevant.

  ---