asked on

unicode and non-unicode string

cannot convert between unicode and non-unicode string. The custdesc in sql table is ntext and casted as nvarchar(1000) in sql cmmand that pulls info into excel. I have changed the excel create table sql to
custdesc nvarchar(1000) ,custdesc ntext null . it does not seem to be working..any inputs?

SOLUTION

BrandonGalderisi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Steve Hogg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ohemaa

ASKER

Checking Advanced Editor inputs outputs pro.

SQl inputs
Name CustomerInfo
Datatype String[Dt_str]
Length (1000)

Excel outputs

Name CustomerInfo
Datatype String[Dt_str]
Length (1000)
but I still get customerinfo cannot convert between unicode and non unicode string data types

SOLUTION

Steve Hogg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ohemaa

ASKER

solution from google. add data conversion and convert customerinfo to unicode

Steve Hogg

OK, a Data Conversion task could work but I am not sure why you are selecting a column from SQL with NTEXT and it becomes a DT_STRING? If the column in SQL is NTEXT and you select it asis, it will come into SSIS as "Unicode text stream [DT_NTEXT]"
Since Excel only understands 6 datatypes from SSIS, see below, and DT_NTEXT is one of them, you should not be getting a unicode coversion error.
SSIS to Excel Datatypes:
Numeric double-precision float (DT_R8)
Currency currency (DT_CY)
Boolean Boolean (DT_BOOL)
Date/time date (DT_DATE)
String Unicode string, length 255 (DT_WSTR)
Memo Unicode text stream (DT_NTEXT)