Do PGNP support copying xml data type ?
I'm getting error like this when trying to copy xml using SSIS from MS SQL to Greenplum postgresql :
[Destination - tablename ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "Convertion of type 13 to string failed (bt=-1, ord=2)
Both ms sql and postgre has xml column.
In SSIS, both ms sql xml column & postgre column detected as unicode text stream.
Need your advice on this..