- Thank you received: 0
XML data type
- kaoru
- Topic Author
- Offline
- User
-
Less
More
10 years 4 months ago #9943
by kaoru
XML data type was created by kaoru
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
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.
- Moderator
-
- Offline
- New Member
Less
More
- Thank you received: 0
10 years 3 months ago #9946
by Moderator
Replied by Moderator on 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!
Thank you!
Please Log in or Create an account to join the conversation.
- kaoru
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
9 years 11 months ago #10739
by kaoru
Replied by kaoru on topic Re: XML data type
Hi...
Is there any update on this xml issue ?
thank u
Is there any update on this xml issue ?
thank u
Please Log in or Create an account to join the conversation.
- kaoru
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
9 years 3 months ago #11429
by kaoru
Replied by kaoru on topic Re: XML data type
Hi, do you have any updates on this issue ?
its already passed 1 year since your last post
thank u
its already passed 1 year since your last post

thank u
Please Log in or Create an account to join the conversation.
- Moderator
-
- Offline
- New Member
Less
More
- Thank you received: 0
9 years 3 months ago #11874
by Moderator
Replied by Moderator on 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!
Thank you!
Please Log in or Create an account to join the conversation.
- Visitor
-
9 years 2 months ago #12482
by
Replied by on 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.
Time to create page: 0.175 seconds