DSXchange

Your Convert() syntax is wrong, looks more like Field() syntax.
Assuming you want to strip any field marks from the output.

I don't believe so. Try doing an exact search for "no more output files", it is saying that you are having a scratch space issue.

There should be an APT variable to "preserve blanks" from what I recall. Ah, yes, found it - set $APT_ORACLE_PRESERVE_BLANKS to TRUE.

One way - add a "before job" ExecSH call to "ulimit -a" (without the quotes) or whatever flavor of ulimit you'd like to run. Then check the logs.

Hmmm... well, then I guess someone else will need to chime in. FYI, you'd need to check the ulimits from inside a job, not 'with the same user' at the command line.

Whenever you change parameters in a job being run from a Sequence job, you need to 'refresh' the job in the Job Activity stage so it can reflect those changes in the stage.

First place to look would be, I assume, wherever you are writing the file. Note you could also have exceeded your ulimit filesize max, typically 2GB.

Well... your rollback requirement means no direct path bulk loads. So you'll need to stick with conventional loads but we'd need more information to give better advice - always inserts? A mixture of inserts / updates? If a mixture, any idea about the ratio?

Don't believe that's possible, AFAIK they import whatever was exported.

Sorry, someone else will need to clarify if that is a manual or automatic thing. I don't have any 8.x access.

Usage Analysis works for files as well if you've stored metadata from the file and linked the metadata to the job by importing it. Or search for "CSeqInput" for a way to query the repository for this. You'll need "CSeqOutput" as well but the search will turn that up.

To answer the question as asked, the colon is the concatenation operator so you could use it to put the two strings together and then convert that string to a timestamp.

Post the complete, unedited error from your logs. Was there an "ORA" component for it?

How can anyone suggest anything without knowledge of your "third pary plugin"? You'd need to involve your support provider for that.

You get this where? Is this a Sequence job or your own job control or ...? Also note there's no reason to "set" a parameter using an environment variable, it will inherit it automatically. That ... It's a sequence job Craig!!!!!!! Jeez, was there a special on exclamation points yesterday ...