Post reply

importing data from text file to unicode columns in sql server table

  • October 25, 2018 at 2:23 pm

    #372364

    SSIS 2016.  importing a column from text file into sql server table into a column of NVARCHAR(50) datatype.
    getting errors that nonunicode and unicode datatypes source/destination cannot be resolved.
    What is the best way to overcome that?

    thank you.

    Likes to play Chess

  • October 25, 2018 at 2:29 pm

    #2011247

    VoldemarG - Thursday, October 25, 2018 2:23 PM

    SSIS 2016.  importing a column from text file into sql server table into a column of NVARCHAR(50) datatype.
    getting errors that nonunicode and unicode datatypes source/destination cannot be resolved.
    What is the best way to overcome that?

    thank you.

    Add a data conversion transformation to convert to unicode before inserting.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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