Post reply

Create txt file in SSIS without NON UTF-8 characters

  • January 29, 2026 at 10:12 pm

    #4726470

    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. SSC utf8 issue

    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

  • January 29, 2026 at 10:16 pm

    #4726471

    Please ignore/delete this post, it is a duplicate. Apologies for the inconvenience.

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply