SQL Server Performance

Error on SSIS, Source destination: cannot convert between unicode & non-unicode string data type

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Mar 3, 2008.

  1. Ismailc New Member

    Hi, I need help please!
    I get the following error on my OLE DB Destination: column"Oprcode" cannot convert between unicode & non-unicode string data type.
    Please Assist on what i should do!
    Regards
    Ismailc, Mar 3, 2008
    #2

  2. satya Moderator

    satya, Mar 4, 2008
    #3

  3. Ismailc New Member

    Thank You very much - the conversion worked well!
    I also had a warning where the source length was longer than the destination length.
    And thanks to your link i knew how to set the length using the advanced editor - input & output properties.
    Thank You
    Ismailc, Mar 4, 2008
    #4

  4. Ping_Jo New Member

    Thanks alot...Very much useful!!
    Ping_Jo, Aug 25, 2009
    #5

  5. Dominick New Member

    Sathya its really reduced my time to solve this. Great Work!!!!!!!!!!
    Dominick, Aug 30, 2012
    #5

Share This Page