Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Cannot convert between unicode and non-unicode

Author  Topic 

jrp
Starting Member

4 Posts

Posted - 2009-07-01 : 09:11:58
Im finding Im getting the above errors because Im trying to convert from a nvarchar source column to varchar destination column. Thought an easy fix would be to add the Data Conversion tool however does not seem to work and keep getting the same error (I tried converting Unicode string[DT_WSTR] TO string[DT_STR]). It may be possible to convert from varchar to nvarchar as I saw it in other forums however I need to convert it this way around. Ideally I do not want to alter by tables.

Any Ideas?

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-01 : 09:44:44
http://msdn.microsoft.com/en-us/library/aa337316(SQL.90).aspx
Go to Top of Page
   

- Advertisement -