Problem with datatypes...

Dear Friends,

I have a problem with datatypes....

The error is "Cannot convert between unicode and non-unicode..."

The column in source is nvarchar(32) and in the destination is varchar(32)... ok...

But in the DataReader Source in the SQLCommand I've converted the column into varchar(32) with

convert(varchar(32), Equities.Equities_Name) as CL_FOLDER_ID

Do you have any tip?

Thanks!

Look at the actual output column for the Source, and you will see that that is DT_WSTR, the unicode string type in SSIS. The DR source does not support non-unicode strings, everything becomes a .Net string in the ADO.Net provider world, and and then SSIS will always treat these as DT_WSTR. If you used the OLE-DB Source through, you get support for both DT_STR and DT_WSTR, mapped from nvarchar and varchar respectively.

So in summary since your source will always give you DT_WSTR, you will need to use a conversion transform inside the pipeline, see Derived Column or Data Conversion, either will do.

|||

Darren,

I used the conversion, but I i tryied to use in SQL command, but if it's not possible, OK... I will use the conversion transform...

Thanks!!