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
  2. satya Moderator

  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
  4. Ping_Jo New Member

    Thanks alot...Very much useful!!
  5. Dominick New Member

    Sathya its really reduced my time to solve this. Great Work!!!!!!!!!!

Share This Page