Every one of the columns in my resource table are varchars therefore when I developed my location table, I saw to it that they had the very same information kinds. So both tables have varchar information kinds for all columns.

Nevertheless, I am still obtaining the mistake: Column "col1" can not transform in between unicode and also non-unicode string information kinds. The unusual point is that if I change my OLE DB Location with a Trouble Web Location, it appears to function nevertheless, I wish to make use of OLE DB to ensure that I can defining points such as rows per set.

Can anybody aid?

sql-server ssis
Enhance this inquiry
Adhere to
asked Nov 28 "18 at 16:23

12111 gold badge11 silver badge22 bronze badges
Include a remark|

1 Solution 1

Energetic Oldest Votes
Dual click the line in between the resource and also location as well as pick the Metal tab. That will certainly detail every one of your columns as well as the information kinds SSIS has actually presumed.

I would certainly contrast that to your resource as well as 100% guarantee they line up.

What can occur is that the very first time you developed your information circulation, SSIS will certainly establish the metadata based upon what the kinds go to that factor. col1 is translated to be nvarchar so it"ll established it as DT_WSTR of some size.

Time passes as well as you upgrade the resource and also the inquiry is currently varchar, yet still called col1. A varchar will certainly constantly suit an nvarchar so the form of that column hasn"t "transformed" so SSIS doesn"t demand to remodel it"s internals.

My click course is to [it is the situation that SSIS is sticking to old metadata [/p> Duplicate the existing queryChange my inquiry to pick 1 as TotallyNewAndUniqueColumnSSIS will certainly then report that all my metadata runs out whack as well as would certainly I such as to autofix it, as well as I click YesRepaste the initial inquiry as well as lo and also behold, the present metadata is recorded.
Boost this response
Adhere to
addressed Nov 28 "18 at 16:32


15.3 k44 gold badges4646 silver badges8686 bronze badges
Include a remark|

Your Solution

Many thanks for adding a response to Data source Administrators Heap Exchange!

Please make certain to address the concern Offer information as well as share your research study!

However stay clear of ...

Requesting for assistance, explanation, or reacting to various other answers.Making declarations based upon point of view; back them up with recommendations or individual experience.

To get more information, see our pointers on creating terrific responses.

Draft conserved
Draft threw out

Join or visit

Join making use of Google
Register utilizing Facebook
Register making use of Email and also Password

Message as a visitor

Email Required, however never ever revealed

Blog post as a visitor


Needed, yet never ever revealed

Article Your Response Discard

By clicking "Blog post Your Solution", you consent to our regards to solution, personal privacy plan as well as cookie plan

Not the solution you'& #x 27; re searching for? Search various other inquiries labelled sql-server ssis or ask your very own inquiry.

The Overflow Blog site
Included on Meta
When making use of SSIS with Oracle [quiet truncation of last personality [br> 13
ETL: removing from 200 tables - SSIS information circulation or personalized T-SQL?
Transforming Non Unicode string to Unicode string SSIS
SSIS Dataflow Job concern, relocating information from SQL Web server 2008 to MySQL through ADO.Net
SSIS export to level documents - just how to set up all DataTypes for columns w/o handbook access?
SSIS Information Transfer vs. Connected Web Server
ssis can not transform in between unicode as well as non-unicode information kinds despite the fact that the location and also the resource columns are both unicode
Warm Network Questions much more warm concerns

Concern feed
Register for RSS
Concern feed To register for this RSS feed, duplicate and also paste this link right into your RSS viewers.


Data source Administrators
Heap Exchange Network
website style/ logo design © © 2021 Heap Exchange Inc; individual payments certified under cc by-sa. rev2021.10.21.40537

Data Source Administrators Heap Exchange functions ideal with JavaScript allowed

Your personal privacy

By clicking "Approve all cookies", you concur Heap Exchange can keep cookies on your tool and also divulge details based on our Cookie Plan.