July 23, 2014 at 8:07 am
Hi,
I have excel source and oledb destination. I am facing few errors ' ID cannot convert between unicode and non unicode datatypes'
So i am changing in both excel and oledb destinations from DT_WSTR to DT_STR using advanced editor. It changes in excel source but not in oledb destination. I changed from DT_WSTR To DT_STR and selected okay at destination. Reopening shows me the same DT_WSTR but not the changed one.
July 23, 2014 at 10:29 am
For the destination you actually have to modify the column in the table because the destination is getting it's data types from the meta data of the destination. I usually just use a Derived Column transform to fix these issues.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 23, 2014 at 10:39 am
It occasionally works to change the output on your source. The safest means to ensure it is the proper type though is to use a derived column transform like Jack mentioned.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply