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: 279
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

yxfy <a href=http://www.mauijimhorsetrials.org/HerveLeger.ph

Postby ljtbkqzsvyrg » Sun Apr 20, 2014 7:20 am

If there is no wind, the sky will not cry, if there is no spring, but i do not know there is no spring. Celine Taschen Bottega Veneta Outlet Bullish Calls:Chesapeake Energy (CHK): I do believe that he (CEO Aubrey McClendon) does have a pretty good, cool hand on things cool hand Aubrey, between $5 and $7, we are fine with that company I see every time that I read about a new shale, he has got stake in that new shale this guy is everywhere, he is doing a great job if Boone Pickens is right, and we have got a Natural Gas Act that comes up by Memorial Day I will tell you without any doubt that I think Chesapeake could go up 50% a winner and a keeper. Celine Outlet Celine Bag Barneys TechCrunch Herve Leger Celine Bag Price One cool thing is the TVs in the suites have 50 different channels. Herve Leger A so-called love; it is so hard to find we are so deep why are convinced that it is for the inside which a little happiness? Bottega Veneta Deutschland Herve Leger Swimsuit I walked on, tears flow, is moved or something, i don. Bottega Veneta Soldes <a href=http://www.cdisa.ca/BottegaVeneta.php><strong>Bottega Veneta</strong></a> I was entangled, i actually used the word, first listen to the friend said it, i also smiled, what is i don't know the meaning of it, now i'm tangled, nor to the dictionary look up this word in the end what first, use it. Bottega Veneta Deutschland <a href=http://www.cdisa.ca/CelineBags.php><strong>Celine Sunglasses</strong></a> For me, i can only ask you to forgive me, but not to blame you. Portefeuilles Celine
beonlgod http://civitavecchia-olbia.it/BottegaVeneta.php ladqdbte
Posts: 24
Joined: Fri Apr 18, 2014 7:16 pm

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

Who is online

Users browsing this forum: No registered users and 2 guests