XML data type

More
6 years 1 month ago #9943 by kaoru
kaoru created the topic: XML data type
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 :)

Please Log in or Create an account to join the conversation.

More
6 years 1 month ago #9946 by Moderator
Moderator replied the topic: Re: XML data type
Yes, it does. However, there is a bug that prevents copying XML fields in SSIS. We are working on a fix.

Thank you!

Please Log in or Create an account to join the conversation.

More
5 years 8 months ago #10739 by kaoru
kaoru replied the topic: Re: XML data type
Hi...

Is there any update on this xml issue ?

thank u

Please Log in or Create an account to join the conversation.

More
5 years 1 month ago #11429 by kaoru
kaoru replied the topic: Re: XML data type
Hi, do you have any updates on this issue ?
its already passed 1 year since your last post :P

thank u

Please Log in or Create an account to join the conversation.

More
5 years 4 weeks ago #11874 by Moderator
Moderator replied the topic: Re: XML data type
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!

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #12482 by yello
yello replied the topic: Re: XML data type
Is a fix available? I've the same problem.

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #12519 by kaoru
kaoru replied the topic: Re: XML data type
Hi,

have you managed to have the fix on xml data type ?

thank u

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #12626 by Moderator
Moderator replied the topic: Re: XML data type
The fix was released in build 1.4.0.3300.

Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.078 seconds
Powered by Kunena Forum