cannot convert between unicode and non-unicode string data types

Receiving error trying to load into SQL Server table - cannot convert between unicode and non-unicode string data types.  Destination table has varchar database.  Do not want to change data types in destination table, since they match other table definitions in database.  Source data is a query from Teradata.   Can I convert the data so it no longer errors out?
BOATFANAsked:
Who is Participating?
 
BOATFANConnect With a Mentor Author Commented:
This solution did not help - I had indicated that I did not want to change the DDL for the table.  Found that I could run the data thru SSIS using data conversion and then it populated fine.
0
 
BOATFANAuthor Commented:
Data converted successfully.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.