?
Solved

cannot convert between unicode and non-unicode string data types

Posted on 2009-04-01
3
Medium Priority
?
504 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:BOATFAN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 41

Expert Comment

by:ralmada
ID: 24046113
0
 

Accepted Solution

by:
BOATFAN earned 0 total points
ID: 24150401
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
 

Author Comment

by:BOATFAN
ID: 24150482
Data converted successfully.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question