August 31, 2008 at 5:02 am
Hi,
I am new to SSIS and I have created a SSIS package to insert the data from Excel sheet.
My all tables takes the data properly when I convert the varchar field of sql server to string[DT_STR] but for one table the package an error generates
"Name" can not convert between unicode and non-unicode string data type
My old package executing fine but while adding this new table such error occering.
I have field Name Varchar(50) in my table.
Can anybody help me ......................this task is very important for me.:crying:
Thanks in advance
Ajay
August 31, 2008 at 6:06 am
This is because your Excel data seems to include Unicode character.
You need to change the DefaultCodePage in your SSIS package DataFlowTask objects properties.
By default, the Code Page will be 1252, which is ANSI, Latin and it’s the default for most English version of Windows XP.
So by changing the way SSIS handle the character coding of the Source Database, you are good to convert the non Unicode strings to Unicode character using Data Conversion in Data Flow.
http://www.chenjunrong.com/2008/04/ssis-code-page/
For example for Arabic language the code is 1256. You should change it appropriately.
Regards,
Mazharuddin
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 31, 2008 at 6:38 am
Also check and modufy the 'Collation' property of the new table that you have added.
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply