All that the columns in my source table room varchars and so when I produced my location table, ns made certain that they had actually the exact same data types. For this reason both tables have actually varchar data varieties for every columns.

However, i am still obtaining the error: tower "col1" can not convert between unicode and non-unicode wire data types. The weird thing is the if I change my OLE DB destination with a ADO net Destination, it appears to job-related however, I want to use OLE DB so the I deserve to specifying things such together rows every batch.

You are watching: Cannot convert between unicode and non-unicode ssis

Can anyone help?

sql-server ssis
improve this question
inquiry Nov 28 "18 at 16:23

12111 yellow badge11 silver- badge22 bronze title
include a comment |

1 prize 1

active oldest Votes
Double click the line between the source and destination and select the Metadata tab. That will list all of your columns and the data varieties SSIS has inferred.

I would certainly compare that to your source and 100% ensure castle align.

What can take place is that the an initial time you developed your data flow, SSIS will set the metadata based upon what the types are at the point. Col1 is interpreted to be nvarchar for this reason it"ll collection it together DT_WSTR of part length.

Time passes and you update the query and the source is now varchar, however still referred to as col1. A varchar will always fit into an nvarchar so the form of that tower hasn"t "changed" therefore SSIS doesn"t should redo it"s internals.

If that is the situation that SSIS is clinging come old metadata, my click course is come

Copy the present queryChange my query to pick 1 as TotallyNewAndUniqueColumnSSIS will certainly then report that all my metadata is out of whack and also would I choose to autofix it, and I click YesRepaste the original query and lo and behold, the current metadata is captured.
enhance this answer
reply Nov 28 "18 in ~ 16:32

15.3k44 yellow badges4646 silver badges8686 bronze badges
add a comment |

her Answer

Thanks because that contributing an answer to Database Administrators stack Exchange!

Please be certain to answer the question. Provide details and also share your research!

But avoid

Asking because that help, clarification, or responding to various other answers.Making statements based upon opinion; back them increase with references or an individual experience.

To find out more, view our advice on writing an excellent answers.

See more: Listen My Child And You Shall Hear : Book One, Paul Revere'S Ride

Draft saved
Draft discarded

Sign increase or log in

authorize up making use of Google
sign up utilizing Facebook
sign up using Email and also Password

Post as a guest

email Required, however never shown

Post as a guest


Required, yet never shown

post Your prize Discard

By click “Post your Answer”, friend agree come our terms of service, privacy policy and cookie policy

Not the price you're feather for? Browse various other questions tagged sql-server ssis or questioning your own question.

The Overflow Blog
Featured top top Meta
silent truncation of last character once using SSIS through Oracle
ETL: extract from 200 tables - SSIS data flow or custom T-SQL?
converting Non Unicode string to Unicode cable SSIS
SSIS Dataflow job issue, moving data indigenous SQL Server 2008 come MySQL via ADO.Net
SSIS export come flat record - how to configure all DataTypes because that columns w/o hands-on entry?
SSIS Data transfer vs. Connected Server
ssis cannot convert in between unicode and also non-unicode data types even though the source and the location columns room both unicode
warm Network inquiries much more hot inquiries

concern feed
i ordered it to RSS
concern feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.


Database Administrators
ridge Exchange Network
site style / logo © 2021 ridge Exchange Inc; user contributions license is granted under cc by-sa. Rev2021.10.18.40487

Database Administrators ridge Exchange works finest with JavaScript enabled

her privacy

By click “Accept all cookies”, you agree ridge Exchange can store cookies on your an equipment and disclose information in accordance with our Cookie Policy.