DSXchange

As noted - way more better, but not solved yet. Still seeing double and triple posts.

If Ray will reply with a long enough reply I will test this since I am not a premium member. Hey trobinson, The fact that you have been registered with DSX since 2002, and with quite a lot of posts, but without a premium membership yet, does incline me to believe that ... 'may be it is possible'. J...

VCinDSX is also running a Windows server, so memory management issue could be a little different there.

I feel the short answer to the "Is this warning is due to processing of large xml files?" question is a simple "yes".

You can A) script a call to sqlldr to load either .dat file or B) switch #2 to Automatic mode.

Well... you could try.

"Not working" means what here, what ends up in the job? And what stage / database are we discussing here?

Like Ken, I really don't understand all this discussion on 'saving space'. Those kinds of concerns are the domain of the Modeller and the DBA. As the person loading the table, your job is to get the data shoved in and it falls to others to worry about the efficiency of the table / index design, tabl...

vmcburney wrote:I think the 7.5.3 release will have a collection of defect fixes and patches consolidated and will probably be the last 7.5.x software release.

That's what I recall hearing as well, just thought it was supposed to be out by now.

That and Reset the aborted job, then let us know the contents of any 'From previous run...' log message.

Then you are asking it to run a job that is already running.

What does that have to do with the topic we are discussing? What job? Did you set each Job Activity stage to 'Reset if required then run' or just 'Run'?

If you "dont want to have any dependency and just run from beginning everytime the anything fails" then do not enable the "Add checkpoints" option. Simple as that.

i the above command does not help. How so? The 'above command' is simple to implement and all you need. Adding a routine to actually read the file, seek to the end of the output file and append the records is an unnecessary complication. Unless, of course, you need to manipulate the records in some...

"cat trailer_record >> detail_records"

Escape the quotes by putting a back-slash (\) before each one.