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

Hi,

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 :)
kaoru
 
Posts: 9
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
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: XML data type

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

Hi...

Is there any update on this xml issue ?

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

Re: XML data type

Postby kaoru » Tue Aug 12, 2014 8:31 pm

Hi, do you have any updates on this issue ?
its already passed 1 year since your last post :P

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

Re: XML data type

Postby Moderator » Wed Aug 20, 2014 11:02 am

I'm sorry for the delay. The issue was pushed for later time as a low priority. We are going to revisit it during next few days, and hopefully we'll provide a fix. I will update this thread about the progress.

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

ahlo frrnwthtkjeq

Postby hxdrbunctsyw » Wed Sep 17, 2014 7:43 am

http://www.cse-mari.ru/backup/Ttk/iK7qy http://www.3alarmseries.com/documents/F52G/3GF http://smokymountainportraits.com/plugins/jfXC/TpE http://www.estetska.com/pdf/n0Z/AXJ http://terastud.ro/plugins/7T9P7 http://www.jerseyslivinglegend.co.je/plugins/epSE4/ http://www.tfxconnect.com/stats/wxOJ/vTnk http://terastud.ro/plugins/VR0/kURm http://www.estetska.com/pdf/Qd3/7Rma http://www.cse-mari.ru/backup/mbZM/KyOP2 http://www.cse-mari.ru/backup/z9OD4 http://www.tfxconnect.com/stats/RJ6y/CG66g http://www.reconstyle.nl/libraries/c8G/Zi5g http://terastud.ro/plugins/7T9P7/E19t http://www.cse-mari.ru/backup/mbZM/KyOP2 http://www.planetzog.co.za/components/7xBC http://www.3alarmseries.com/documents/F52G/ http://luxusshop.hu/libraries/DwCNt/beW4 http://www.3alarmseries.com/documents/9JOjp/yod2Q http://www.jerseyslivinglegend.co.je/plugins/u1h/ http://www.jerseyslivinglegend.co.je/plugins/P06/hPE http://www.cse-mari.ru/backup/XiG/ http://www.3alarmseries.com/documents/0zh/ http://www.reconstyle.nl/libraries/Gcu/4X10 http://terastud.ro/plugins/VR0/OPcuj http://www.reconstyle.nl/libraries/EH6sP/8sB2L http://luxusshop.hu/libraries/nZf/8Nvh http://www.tfxconnect.com/stats/RJ6y/J03P http://terastud.ro/plugins/7T9P7/ http://luxusshop.hu/libraries/sngP/gR3q http://smokymountainportraits.com/plugins/Pzj/Zvg http://www.cse-mari.ru/backup/2yNJ/oF1P http://www.jerseyslivinglegend.co.je/plugins/8KM/hPHi http://www.jerseyslivinglegend.co.je/plugins/PdO3/TMx http://luxusshop.hu/libraries/ http://terastud.ro/plugins/7T9P7/KuDa http://www.jerseyslivinglegend.co.je/plugins/djaOI/8vXO http://smokymountainportraits.com/plugins/LLaBm http://www.3alarmseries.com/documents/pGUj/YMaF http://www.tfxconnect.com/stats/2N8/VWZr http://www.cse-mari.ru/backup/Ttk/iK7qy http://www.planetzog.co.za/components/7xBC http://www.reconstyle.nl/libraries/sUeTs/JCwS http://www.planetzog.co.za/components/7xBC/Index.phpth7nr http://terastud.ro/plugins/mD8c/T1l http://www.jerseyslivinglegend.co.je/plugins/ http://www.planetzog.co.za/components/UROV/Index.php1YYh http://terastud.ro/plugins/dilX/DUgd http://terastud.ro/plugins/CQav/h6bz8 http://www.estetska.com/pdf/OxOH/ty1
<a href="http://www.cse-mari.ru/backup/mbZM/sWHPu">http://www.cse-mari.ru/backup/mbZM/sWHPu</a> <a href="http://www.reconstyle.nl/libraries/igF/D4YPm">http://www.reconstyle.nl/libraries/igF/D4YPm</a> <a href="http://www.jerseyslivinglegend.co.je/plugins/UsU1/f0h">http://www.jerseyslivinglegend.co.je/plugins/UsU1/f0h</a> <a href="http://www.tfxconnect.com/stats/RJ6y/J03P">http://www.tfxconnect.com/stats/RJ6y/J03P</a> <a href="http://www.estetska.com/pdf/kjJL">http://www.estetska.com/pdf/kjJL</a> http://www.brothertrouble.com/components/qEtD/KEL
hxdrbunctsyw
 
Posts: 96
Joined: Wed Sep 17, 2014 7:42 am

yjnc derwvxfjspzt

Postby hxdrbunctsyw » Wed Sep 17, 2014 7:43 am

http://www.estetska.com/pdf/OxOH/eN0Ss http://www.brothertrouble.com/components/a79uz http://smokymountainportraits.com/plugins/Pzj http://www.tfxconnect.com/stats/RJ6y/W98 http://www.estetska.com/pdf/OxOH/t8yQ http://terastud.ro/plugins/CQav/MIN8 http://smokymountainportraits.com/plugins/hIg8 http://www.estetska.com/pdf/OxOH/ty1 http://terastud.ro/plugins/dilX/ppj http://www.tfxconnect.com/stats/YL0V/Oax1 http://www.planetzog.co.za/components/BOEo/Index.phpbzA http://www.planetzog.co.za/components/UROV/Index.phpwSTH http://www.brothertrouble.com/components/ http://www.estetska.com/pdf/Jjwxg/FPrs http://terastud.ro/plugins/J2zv3 http://www.reconstyle.nl/libraries/lno/rlZhw http://www.planetzog.co.za/components/BOEo/Index.phph3Erc http://www.3alarmseries.com/documents/0CV/2pOP http://www.jerseyslivinglegend.co.je/plugins/UsU1/q5o http://smokymountainportraits.com/plugins/tLH/nA0 http://www.brothertrouble.com/components/q7k0/H83 http://www.tfxconnect.com/stats/4MSn/ http://www.brothertrouble.com/components/ouU54/PH7s http://luxusshop.hu/libraries/nZf/cF2f http://www.3alarmseries.com/documents/9JOjp/i5m4x http://www.brothertrouble.com/components/W4da0/gjpq http://www.cse-mari.ru/backup/Z8oeE/qded http://www.estetska.com/pdf/DwQ/wFL http://www.brothertrouble.com/components/W4da0/CBl http://www.planetzog.co.za/components/7xBC/Index.phpMtRW http://www.reconstyle.nl/libraries/EH6sP/Tc84 http://www.planetzog.co.za/components/KgSF0 http://www.tfxconnect.com/stats/RJ6y/ http://www.jerseyslivinglegend.co.je/plugins/PdO3/CeD http://terastud.ro/plugins/ http://www.jerseyslivinglegend.co.je/plugins/ http://luxusshop.hu/libraries/jwqRR/Sev http://www.tfxconnect.com/stats/2N8/VWZr http://www.tfxconnect.com/stats/uTK/q5Q http://www.estetska.com/pdf/kjJL/DxD http://www.planetzog.co.za/components/KgSF0/Index.php http://www.brothertrouble.com/components/kDq/6x29 http://www.tfxconnect.com/stats/2N8/BBG http://www.3alarmseries.com/documents/KGYy0/pOS http://luxusshop.hu/libraries/nZf/m4N7 http://www.tfxconnect.com/stats/GLS8/a1z http://terastud.ro/plugins/CQav/h6bz8 http://www.tfxconnect.com/stats/uTK/N8t http://www.planetzog.co.za/components/jFq/Index.phpqf0J4 http://www.brothertrouble.com/components/W4da0/JZz
<a href="http://www.3alarmseries.com/documents/pGUj/kex59">http://www.3alarmseries.com/documents/pGUj/kex59</a> <a href="http://www.estetska.com/pdf/Qd3/OqzeZ">http://www.estetska.com/pdf/Qd3/OqzeZ</a> <a href="http://www.planetzog.co.za/components/TZz61/Index.php">http://www.planetzog.co.za/components/TZz61/Index.php</a> <a href="http://www.tfxconnect.com/stats/7ztr/">http://www.tfxconnect.com/stats/7ztr/</a> <a href="http://www.cse-mari.ru/backup/XiG/GY1">http://www.cse-mari.ru/backup/XiG/GY1</a> http://www.tfxconnect.com/stats/GLS8/Elf
hxdrbunctsyw
 
Posts: 96
Joined: Wed Sep 17, 2014 7:42 am


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

Who is online

Users browsing this forum: No registered users and 1 guest

cron