September 16, 2008 at 12:21 am
I have a flat file.In that one colums as string(dt_str).When I am trying to load this flat file to sql server destination table .I am getting error that "can't covert non unicode to unicode string data types"?any suggestion on this?
September 16, 2008 at 6:41 am
The error is telling you exactly the problem the text file is returning a non-unicode string and the database column is a unicode string type (nchar/nvarchar) and you need to convert the value to unicode in order to insert it into the table. You need to use a Data Conversion Transform to do this.
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
September 17, 2008 at 5:40 am
hi,
If the data type in the database is varachar or nvarchar then you must use the dt_wstr datatype in SSIS. So use the derived column in the SSIS then convert the dt_str datatype to dt_wstr datatype.
Vijay
October 9, 2008 at 12:56 am
hi,
Had you got the problem solved mate
vijay
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply