XML data type

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

XML data type

Postby kaoru » Mon Aug 05, 2013 8:53 pm


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 [22]] 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..

Thank u :)
Posts: 8
Joined: Tue Dec 18, 2012 5:01 am

Re: XML data type

Postby Moderator » Mon Aug 12, 2013 7:17 am

Yes, it does. However, there is a bug that prevents copying XML fields in SSIS. We are working on a fix.

Thank you!
User avatar
Site Admin
Posts: 293
Joined: Wed Oct 29, 2008 11:27 pm

Re: XML data type

Postby kaoru » Tue Jan 07, 2014 7:03 pm


Is there any update on this xml issue ?

thank u
Posts: 8
Joined: Tue Dec 18, 2012 5:01 am

Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests