Create txt file in SSIS without NON UTF-8 characters

• Lord Slaagh

  SSCertifiable

  Points: 5795

  More actions

  January 29, 2026 at 10:11 pm

  #4726468

  Hello SSC Community,

  I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version. 

  I changed the code page to 65001 (UTF-8) and changed the data types to Unicode String [DT WSTR] and that created a text file with just the header. Does anyone know of this issue and have a workaround?

  Any assistance would be greatly appreciated!

  Dave

   

   

  The are no problems, only solutions. --John Lennon