DSXchange

How well did it work when you had separate jobs?

Don't try to do this unless you first have a job that successfully pulls content in the first XMLStage and sends it to a file, and then a second job that successfully parses that resulting file.

Ernie

Please read again my prior entry. If the data coming in looks like you have pasted, then it is one xml document "inside" the other....you need two xml stages...one after the other in succession.

Ernie

I'm kind of lost as to the ultimate goal and what things look like....are you creating this from a set of rows coming in, or reading it, or both?

Sorry. I see what you are getting at...you mean changing the text at the generic Info Server Console. Hmm. The custom logo shows up there just fine, but the text is not "easily" accessible. Hey --- we have to get some branding and advertising in "somewhere". ; ) Ernie PS...I'm su...

Yep. Edit Settings. Main Info Server Web Console Glossary tab...at the bottom.... not sure if BG Admin role is allowed to do it, but the Information Server admin definitely can...you can change the text, and the logo along with other global BG settings.

Ernie

Hi Vincent... For those of us with years of SQL experience, the selection criteria behavior in Workbench can be a bit confusing. What it is doing is qualifying the original highest level object (the one in the pull down), by all of the criteria that you have established....then, once it qualifies th...

Let this be a lesson to anyone who reads this thread in the future.......DON'T use the Sequential Stage in Parallel Jobs to read XML from disk. It's simply too unpredictable. Variable length strings, stray carriage returns and other xml "noise" characters etc can cause the Sequential Stage...

PS. "For my sins I'm working back at the company who tortured me with XML".....



Oh, come on, XML is fun! And now that Ray and IOD let the cat out of the bag, it's going to get even more fun [and better] in the near future.

Ernie

Hi Andrea... I can't exactly say why it's checking the XSD if you don't have Validation checked, but the error seems like a "clean" one (meaning...it "is" comparing the incoming document to the xsd, and it doesn't like it). If you have time, research it more. Get yourself a copy ...

Both formats (the one you are getting and the one you want) without more detail at this point seem kinda screwy. Why is <PAIEMENT> in your first example repeated? Are the elements beneath it repeated? Uniquely identified? The elements beneath it ought to be the repeating element, and aggregation sho...

It "looks" like you have xml inside of xml...meaning...you have a very primitve document called "CompressableData" with one element called PMxml, and it contains itself.....another xml document. It's an interesting technique that comes up once in awhile, most often when people wa...

Hard to say, except that it "looks" like it is doing validation and finding that you have an element that shouldn't be there.........(it's not known to the xsd). You may have an old xsd, or it's truly a bad element. Right now it looks like it is a legitimate error. Get a copy of the xsd an...

Looks like an authentication error, especially since you are getting a formal "soap fault" returned to you.....or else maybe it's just a bogus endpoint for your web service (ultimately the wrong server or wrong url address)... What happens when you run the service using an external tool, s...

Hi a ... Nothing like that (metaarchitect) exists any longer, but Metadata Workbench does provide the mechanism to bring in artifacts called "Extensions". Extensions can represent processes or abstract objects like Applications or message queues. Tables and columns can already be imported ...

just guessing at this point, but the next suggestion is to start doing some unicode research for info that might need to be in the header....right now it appears that there is no header, but one might be needed based on the characters that may exist deep in your document. It looks like an ACORD insu...