locked
Error at Data Flow Task[OLE DB Destination [36]]: Column "Name" cannot convert between unicode and non-unicode string data types RRS feed

  • Question

  • User-471451108 posted

    I am working on SSIS and i am importing excel data into tables. And i am using

    Data flow task->Excel Source->Lookup->Multicast->OLE DB, OLE DB, OLE DB.

    When i want to run the package, i am getting below error.

    I cant use Data conversion.

    Actually, When i used data coversion, its working fine. And in tables, i chnaged the data type into nvarcha(100). Then also its worked fine.

    I need to solve this issue, when my database columns datatypes are in varchar and without using Data conversion.

    Error at Data Flow Task[OLE DB Destination [36]]: Column "Name" cannot convert between unicode and non-unicode string data types

    Wednesday, April 10, 2013 4:25 AM

Answers

  • User1800260989 posted

    You can use Data Conversion.

    Your source -> data conversion -> destination

    Configure data conversion select the input and change the datatype from DT_WSTR to DT_TEXT.

    Configure the destination in the mapping select the input column from the data conversion.

    That can help you to fix the problem.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 17, 2013 4:11 PM

All replies

  • User-1280676833 posted

    Did your issue fix? If not, please don't mark your question as answer.

    Friday, April 26, 2013 1:43 AM
  • User1800260989 posted

    You can use Data Conversion.

    Your source -> data conversion -> destination

    Configure data conversion select the input and change the datatype from DT_WSTR to DT_TEXT.

    Configure the destination in the mapping select the input column from the data conversion.

    That can help you to fix the problem.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 17, 2013 4:11 PM