September 15, 2012 at 9:23 am
hi,
i am inserting data from flat file to sql table usig SSIS.
my flat file is
empid,empname,salary
1,david,1000
2,krik,3456
3,van,4532
4,venus,345
my table in sql is
create table emp
(empid int,
empname nvarchar(50),
salary int)
now when i insert int oledb des, i am getting error like
"Column empname cannot convert between unicode and non unicode data type"
why this is coming and how to solve it
September 15, 2012 at 5:12 pm
try playing around with the datatype of the empname on the source between WSTR and DWSTR.
September 15, 2012 at 10:09 pm
You're delivering to a unicode string (nVarchar) and your file source definition is most likely string instead of unicode. Modify the source to be unicode, or use the datatype converter tool and generate a new column switching from non unicode to unicode, and put that into the target table.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 19, 2012 at 12:57 am
Use a data conversion task to convert the non unicode valuesto unicode valued, it will resolve the issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply