Loading

Cannot convert between a unicode and a non-unicode SSIS

Sujeet Raman

When I run ssis package I receive this error "cannot convert between unicode and non-unicode string data types", my source is Sql db and when I check my output columns data type they are all Unicode string[DT_WSTR]( changed the o/p parameters but still error)and my destination which is SQL data type for Input Columns are DT_WSTR . how can I do this conversion?

help are appreciated in advance friends

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Can you try this https://stackoverflow.com/questions/15547539/ssis-convert-between-unicode-and-non-unicode-errorhttps://www.sqlservercentral.com/articles/solving-an-ssis-error-–-cannot-convert-between-unicode-and-non-unicode https://youtu.be/pXZONSHb-es https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b66a644b-d8d8-44e8-9179-f569f429b079/cannot-convert-between-a-unicode-and-a-nonunicode-string-data-types?forum=sqlintegrationservices