Last post Jul 17, 2013 04:11 PM by Karen Rivero
Apr 10, 2013 04:25 AM|vsp.santu|LINK
I am working on SSIS and i am importing excel data into tables. And i am using
Data flow task->Excel Source->Lookup->Multicast->OLE DB, OLE DB, OLE DB.
When i want to run the package, i am getting below error.
I cant use Data conversion.
Actually, When i used data coversion, its working fine. And in tables, i chnaged the data type into nvarcha(100). Then also its worked fine.
I need to solve this issue, when my database columns datatypes are in varchar and without using Data conversion.
Error at Data Flow Task[OLE DB Destination ]: Column "Name" cannot convert between unicode and non-unicode string data types
Apr 26, 2013 01:43 AM|Young Yang - MSFT|LINK
Did your issue fix? If not, please don't mark your question as answer.
Jul 17, 2013 04:11 PM|Karen Rivero|LINK
You can use Data Conversion.
Your source -> data conversion -> destination
Configure data conversion select the input and change the datatype from DT_WSTR to DT_TEXT.
Configure the destination in the mapping select the input column from the data conversion.
That can help you to fix the problem.