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: 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
Moderator
Site Admin
 
Posts: 294
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: 8
Joined: Tue Dec 18, 2012 5:01 am

Oakley M Frame Safety Glasses

Postby dwfcllmudn9R » Fri Aug 01, 2014 12:37 pm

tips on choosing the right variety glassesadvice on is important a small amount of sun cheap batwolf oakley sunglasses ray ban sunglasses, ,
You can skim through and then switch to another store if you don't like any. What a hassle will that be with a brick and mortar store! Plus, you can also easily narrow your search using keywords, for instance aviators.. cheap oakleys sale gucci sunglasses, ,
The craze for designer sunglasses is peaking. Every other boy and girl on the street is sporting one. No doubt it suits some, but what about the rest? Do they look like a bunch of jokers to you? It is simply because they may have not chosen the right frame. The frame of the designer glass should be according to your face construction. Though sunglasses are supposed to shield your eyes from harsh sun rays, it is also worn to make a fashion statement. authentic oakley sunglasses ray ban sunglasses, ,
Many of people like these peoples due its shape or its best feature it is eco friendly and have no side effect. Or in usually or normal sunglasses are made of metal and uses chemical to shade it better that chemical are harmful for skin so lot of people wish or attracted forward to wooden sunglasses.
.
dwfcllmudn9R
 
Posts: 47
Joined: Fri Aug 01, 2014 2:00 am

Oakley Holbrook Polarized Matte Black

Postby dwfcllmudn9R » Fri Aug 01, 2014 12:45 pm

ons they still exist in the market with the name of fit oversyou can still enjoy your outdoor sport discount oakley sunglasses ray ban sunglasses, ,
We had better make sure the lens diameter within 62 mm, which can accord with the our diopters and pupil distance easily. The main color of prescription sunglass lenses is grey and brown. The objects we focus on will not be distorted when we wear a pair of prescription sunglasses with grey or brown lenses. ray ban sunglasses, ,
With the men and women who are tired of wearing inexpensive sunglasses, getting a pair of new designer eyewear from the site will probably be a breath of clean air. Aided by the quite a few choices accessible, 1 will be capable to discover unique designs and designs from timeless aviators to other varieties of eyewear in distinct shades and sizes. Together with the wide choice readily available about the internet site, shielding your eyes from bright lighting or the sun will likely be far more chic. Sunglasses are an excellent expression of a singleâs taste and choosing the correct type, suitable fashion and even the right shade is like finding a thing worth employing for the lengthy time. With sensible prices and hundreds of options, youâll get pleasure from purchasing with the good sunglasses via the site. In fact, you are able to discover the ideal pair which youâll have the opportunity to make use of in different seasons and oakely sunglasses wholesale mk sunglasses, ,
Online shopping: With the advent of E-buying, you no longer have to brave the sun, wind, rain and traffic congestion to procure a pair of glares. Apart from saving time and energy while shopping online, you may even strike a good bargain and grab a trendy pair at a throwaway price.
.
dwfcllmudn9R
 
Posts: 47
Joined: Fri Aug 01, 2014 2:00 am


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

Who is online

Users browsing this forum: No registered users and 1 guest

cron