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: 12
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: 303
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: 12
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: 12
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: 303
Joined: Wed Oct 29, 2008 11:27 pm

Re: XML data type

Postby yello » Wed Oct 01, 2014 1:25 am

Is a fix available? I've the same problem.
yello
 
Posts: 7
Joined: Wed Jul 09, 2014 1:20 am

Re: XML data type

Postby kaoru » Wed Oct 15, 2014 1:37 am

Hi,

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

thank u
kaoru
 
Posts: 12
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 1 guest

cron