fetches a column with datatype varying character as UNICODE

[sashikanth.ratnala@gmail.]

“OLEDB provider for Green Plum when used in SSIS 2008 fetches a column with datatype varying character as UNICODE. Is this the expected behaviour?

Version of Provider is 1.3.0.2196”

[Moderator]

Yes, it is default behavior - provider convert utf8 into Unicode wide character string. Does that cause any issue?

[sashikanth.ratnala@gmail.]

When we are fetching data from Greenplum database using this driver to SQL Server, we have to use Data Conversion transformation to convert from unicode string to non unicode string ideally which is not advisable to use.

[Moderator]

We have created a ticket for this issue. It will be fixed in one of the future update releases.

Thank you!
PGNP Team