Export Hebrew to flat file returns as ?????

• ran.ovadia

  Ten Centuries

  Points: 1183

  More actions

  April 16, 2012 at 6:57 am

  #267446

  Hi,

  I have a SSIS which was run on Windows Server 2003 and SQL 2008 and export Hebrew as needed but when I run this SSIS from Windows Server 2008R2 and SQL 2008R2 Sp1 I get the hebrew in the exported file as ????? but numbers are fine.

  Can any body help me?

  Thanks,

  Ran.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  April 17, 2012 at 1:29 am

  #1474542

  Make sure you export the data as unicode.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• ran.ovadia

  Ten Centuries

  Points: 1183

  More actions

  April 17, 2012 at 2:14 am

  #1474566

  Thanks, I just changed the regional settings...

  Now it works.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  April 17, 2012 at 2:15 am

  #1474567

  ran.ovadia (4/17/2012)

  ---

  Thanks, I just changed the regional settings...

  Now it works.

  Great, glad that you got it working.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP