DSXchange

Target database? Stage used? Derivation? Details, man, details!

I don't believe it is valid for your version or it would have come with it. Better if you find any post by kduke and check his 'sig' block for a website link. There you'll find a downloadable document from Ascential on XML Best Practices - it will help alot more than the one you are looking for.

You can. What have you tried since your first post? Narasimha posted a link to another thread but you never said if it helped, what you tried, errors you are getting... other than the little bit in your first post. How have you defined your namespaces in the XML stage? Specifically, the 'default na...

I'm not sure what you mean by 'propogate the id column for a particular blob', can you provide a specific example? Typically, in an XML stage columns declared without an XPath Expression simply propogate down the link, but I'm not sure if that's what you are looking for or not...

Much like Jello, there's always room for tuneups.

Actually, there's no need to 'wrap' it - call it directly in the SP stage and you can trigger it as sud mentions. In Server we do this all the time: a single record selected from dual feeds a transformer where job parameters (or hard coded values) are passed down the link to the SP stage which autom...

It would also help if you defined exactly what 'use this rejected data for further processing in the same job' means. And from what I recall, rejected data isn't all that 'usable', per se.

What did you find in the forums when you searched for your error message? I found several conversations when doing an Exact search for 'Caught unknown exception from runLocally', did any of them help?

PeterPol wrote:However, server jobs are very limited in processing possibilities, so I prefer to develop most things in parallel jobs.

Interesting statement. I completely disagree but that's not a topic for this thread.

Datastage doesn't care. Your operating system on the other hand, may. NTFS has no file size limit, by the way.

http://www.ntfs.com/ntfs_vs_fat.htm

Umm... yah. Try them both and tell me which one you prefer.

Your example doesn't mean much of anything. Post the actual xml if you want to give us an idea what you are dealing with. And optional elements shouldn't be a big deal. Have you tried importing the metadata for this file from an .xsd and parsing it in a job yet?

No Folder in PX, you'll need to use the Sequential File stage instead. Quite a number of posts already out there on this subject.

Don't declare them, let them 'default'.

The reason one typically uses a 'sproc' for that is because the user doesn't have the permissions needed, so I would guess that isn't an option. And AFAIK you cannot call one before/after that has OUT parameters. Makes sense as there's no place for them to go, but not positive. For grins, have you t...