February 1, 2010 at 10:49 am
Hi,
While i am trying to convert data from flat file to oledb table, using the following structure and data of flat file and destination table respectively i am getting the following error
error
"column "empno" cannot converted between unicode and non-unicode string datatypes"
please suggest me the solutin for this error
1) destination table
create table employee(empno nvarchar(10),ename nvarchar(20),deptno nvarchar(8))
2)flat file dat
empno,ename,deptno
101,vijay,10
102,anil,10
103,yallamanda,20
104,raja,20
February 1, 2010 at 11:32 am
That error means that you have nvarchar on on one end of the import, and varchar on the other. Change one side either way.
February 2, 2010 at 7:49 am
I usually use a data conversion task to transform the data to the expected data type, unless I can change the destination to the source data type.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply