September 3, 2010 at 5:50 pm
Hi,
I am new to SSIS, I tried to export data to excel from sql server.
I getting the following error. Pls Help
Error at Data Flow Task [Excel Destination [477]]: Column "DB_NAME" cannot convert between unicode and non-unicode string data types.
Error at Data Flow Task [Excel Destination [477]]: Column "ACCT_NBR" cannot convert between unicode and non-unicode string data types.
Regards
Ram...
🙂
September 6, 2010 at 4:32 am
Well, the error is quite self-explanatory:
SSI cannot implicitly convert a string encoded in unicode to a string encoded in another coding schema (or the other way around).
The solution is simple:
convert the datatype of the string (DT_STR) to a unicode string (DT_WSTR). You can use the data conversion component for this. (Or the other way around. I do not know if your source or your destination is in unicode)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply