DSXchange

Exactly, parameter sets with value files should do the trick.

Maybe not. That makes no sense to me, but perhaps the job monitor must indeed be enabled for that to work for a PX job and I lied.

Hopefully someone knows for sure.

After all this discussion, which "this" is the this you wrote a shell script for?

The status DSJS.RUNWARN is obtained when job finishes a normal run with warning. How can i achieve this. The job should not abort but finish with warning. I'm afraid this doesn't make much sense yet. Once a job decides to abort there's no way to make it end with a different status. Are you asking a...

The "this" to achieve here has nothing to do with the original question, unfortunately, but rather from a misplaced bit of advice.

Then I can't help you, not knowing squat about SQL Server nor what this 'family' error could mean. Hopefully someone else does.

Some will tell you the OSH route is 'more accurate' but I don't see how an OSH schema will help you in a Server job, for that importing via the Plug-in Metadata option with OCI is fine. If you like, compare the two and see what (if any) difference there is. And yes, Varchar covers string fields, inc...

If it worked it must be some kind of correct.

More of a typo than a bug and it seems to me you must have had something else in there like a "lib" entry in addition to mispelled "libi32" one or it wouldn't have worked at all... but OK. Bug. As long as you figured it out.

dnat wrote:yeah..But with the link variables i think we should be able to capture it from the transformer itself.

No, because that's not the way it works in parallel jobs.

If someone has and feels like sharing, they will. Patience. For the "unknown error" I'm not sure what you can do other than open a case with your official support provider. For the other, add $APT_DISABLE_COMBINATION to the job and set it to True. That will give you more information regard...

Does the DB2 user you're logging in as "own" any tables? I don't know the proper DB2 term, in Oracle it would be tables in the current user's schema. If the tables are elsewhere, seems to me you'd need to use the Filter option to get to them but I've got no DB2 here to know for sure. Perha...

Funny thing is I don't actually need anything from the CDATA, they're not even part of the fields we're parsing out. Doesn't seem to matter as just their presence puts the big kibosh on being able to do anything. I changed my job from passing just the filename in from the Folder and using the URL op...

Can you do anything Oracle on this new installation? Meaning, can you View Data via the Oracle Enterprise stage in a PX job or from OCI in a Server job? Trying to determining if your Oracle connectivity is completely hosed or if this is strictly a plug-in metadata importing issue.

Not having played much with CDATA in XML, I'm wondering how it is meant to be used. Specifically, this line is in the documentation from a vendor who's XML I am trying to consume: There is no structure to this section other than the value for each element is always contained as a CDATA field to allo...