DSXchange

Wow... that's an amazing display of self control, Ray, holding back a groaner like that.

How did you generate the metadata / XPath Expressions you are using? From an xsd for your source file? Can you post some examples of them, please? Also, did you load your namespace definition? From the docs... If you used the XML Meta Data Importer to create table definitions, select the Include nam...

Me, too.

As noted, it sounds like you may not have exported the entire project. Are you thinking that you did? Are the equivalents of all 'optional' plug-in stages installed in the new server?

Best way? Use a Server job and write to a Folder stage, it can handle the automatic file splitting and naming based on data elements for you. IMHO, of course.

a) You can't change a job parameter value.
b) Why not just script this using split? Don't need to job for that.

Any chance of answering my question? Wondering if this is a single-use-license-queueing issue.

They don't seem to be having any issues actually reading the value from the file, the disconnect seems to be in how they expect to store that in the target table. Even though it has been stated multiple times here already, I'll go through it one more time. * If you want to store "39368,39399,39...

I'd use Convert():

One such 'workaround' would be to remove the delimiters that exist in the data before sending it to sqlldr - is that an option here? If not, I would have a chat with your DBA, they should be well versed in all things Oracle including sqlldr and what you'd need to do to use it with data of that nature.

No. We're either missing some vital piece of information or you're not doing what you are telling us you are doing. Or both. :? Read the field as a string. Move it through the job as a string. Send it to a string field (VARCHAR2) in Oracle. Doing that there is no way you'll get an "invalid num...

I think it's a multiple choice test.

Details, please. Is this a fixed-width file?