DSXchange

What precisely do you mean by this?

"but after moving to the new server we are getting this"

First mention of a new server / server move, so now I'm curious exactly how all this was "moved".

No clue, not having worked with DataStage on Windows. What does your official support provider have to say on the subject?

Do you have or can you get an xsd for this? At a high level, you would select the column from the table and then pass it to an XML Input stage, telling the stage that incoming column was the xml source. Then proper metadata, used in the "XPath Expression" (aka Description) field of the XML...

Looks like plenty of ideas here already, you need to go implement now and let us know how things turn out.

Thanks for posting that, it always helps to have closure or at least some kind of a workaround, especially when people come here searching for help when they have "the same problem".

In version 7, the Director documentation has a full discussion on both of those topics. I would imagine it is in the same place for the 8.x release.

Never said you had to register anything manually, that's all automatic - I specifically said that (AFAIK) you cannot simply move Dynamic Link Library (ddl) files around wherever you like due to the fact that they are registered in a specific location.

I don't believe you can simply move dll files around on Windows, as far as I know they need to be 'registered' in a specific location to work properly. I don't know what environment variable on a Windows server would control access to that plus it seems odd to me that you found it in the Engine's bi...

There's a whole lecture on what is and what isn't "urgent"... I'll leave that to others. Assuming when the condition is not met, the column would be null then derivations would be something like this: audit_id: audit_id audit_type: if condition_type = "un audit" then condition_va...

Just asked for the actual error, not the whole dang log.

ds_loadlibrary: Win32 error in LoadLibrary of sybaseoc.dll - The specified module could not be found.

So, where exactly does this dll live on your server?

Interesting, wasn't aware of that as I tend to avoid ODBC as much as possible.

Could you post the actual full unedited error from your log, please?

Right, once it was corrupted you were out of luck with the resize.

Sorry, but it can't really be "working fine" as Oracle cannot process a DataStage internal date format. However, if the IConv fails, the value will pass through unchanged and so that's probably what is making it look like it is working for you. You really should have a standard for Oracle ...