Post reply

convert between unicode and non-unicode string

  • July 16, 2008 at 6:10 am

    #126460

    I have DTS package to import data from excel file to a table in a database. Now I am building the package in SSIS but after I map the source and destination column I get a error or warning

    Column "column_name" cannot convert between unicode and non-unicode string data types.

    I know that changing the destination column datatype from varchar to nvarchar this error can be eliminated. But I have around 45 database and around 15 tables in each database. I cannot go around and change in each database. Is there any solution to this? why is this problem only in SSIS and not in DTS.

  • July 16, 2008 at 5:26 pm

    #844100

    Hi,

    You need to use Data Conversion task in between to convert unicode to non-unicode. Read about data types in SSIS and then use this this task in between to convert to appropriate data type.

    -V

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

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