Error on SSIS, Source destination: cannot convert between unicode & non-unicode string data type | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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

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

Fyi, http://www.mssqltips.com/tip.asp?tip=1393

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

Thanks alot…Very much useful!!
Sathya its really reduced my time to solve this. Great Work!!!!!!!!!!
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |