DSXchange

Does the job abort? Can you post an example of the warning(s) you are seeing? What database is this?

In general, you can retrieve the number of insert and update operations from link counts in the logs, which is what is noted there but which for anything other than inserts does not necessarily equate one-to-one with records. Check the various "DSGet" functions available listed in the Desi...

Can you post some examples of records from that file?

You'll probably need to read the record as a single long varchar field and then parse it "manually" but examples would help provide better direction.

ORA-12154

Creating a "system DSN" is not part of the Oracle configuration process as the native OCI stage does not use ODBC. What's needed is documented, however.

Can you explain what "getting dropped" means exactly? And detail out your job design so we know what database and stages are involved.

The classic response would be to search the forums here for 'ETLStats', a free framework from Kim Duke that would do all that and more. Your other option, of course, is to roll your own and there are two approaches you can take - a scripted one and a job control / BASIC one. Both would leverage the ...

There is the DIGITS transform that will do that for you.

No, they are only applicable to the Upsert method and are not used by a Load. You would need to expand on your "OPTIONS" clause to include ROWS and, as noted, you really should be discussing that subject with your DBA.

What kind of "details description" are you looking for, exactly?

For DIRECT=TRUE that would be correct. For FALSE it falls back to conventional inserts with commits. And you only get 'all rows at once' by setting the commit interval to a very high number AFAIK. Other options will affect the interval like read size and bind size. You'd really need to have a chat w...

In your shoes, I would ask your DBA.

Use the External Parameter Helper under the ellipsis (...) to pick the variables for you rather than trying to type them in.

You need to take those SMTPMail errors to whomever administers that server and see what they think is going on.

Probably not, but you may be able to get a list of jobs whose last modification date was less than your cutoff date.

OK, try googling for this rather than the UNIX flavor that Arnd posted: "debugging batch files". Also, if you have a full error message, much like was posted in the linked thread about 'error when executing command', can you post the contents of the referenced command file?