DSXchange

Why don't you create a dummy version of the file (say with content like 'FILE NOT FOUND') before attempting the FTP.

After the FTP, check the first line of resulting file.

What happens if you manually do an insert of the same values?

Do you have any other trigger or default values behind the scene?

Something you might have already tried

1.) Copy one of "previous run" files as the new name and try to view
2.) When you "view data", does all required parameter prompts appear?
3.) Is there any special chars in the filename / format section?

Can you perform the same insert outside ds (i.e. through other client like SQL*Plus?

Identify the offending columns by process of elimination.

Give some example of good and bad values. Also provide the format mask you tried.

DS 8 eats your client PC's memory.

Close ALL other memory consuming process (e.g virus scanner, windows updates) and you will see SOME difference.

DS 8 eats your client PC's memory.

Close ALL other memory consuming process (e.g virus scanner, windows updates) and you will see SOME difference.

Create the sql into a file in the pre-job and use external SQL file in the job

Add a dummy column at the end with "Replace" with blank. If this contains value at any time, reject it in the transformer.

I don't have 7.x, but believe you can do a "Where used" from Manager.

Search for static hash files and hash utility.

Work in csv or txt.

Prefix all with a dummy character so all will be text.

Who said Oracle does not use "Parallelism" ? It may be how you have configured it. Doing in a single query may inturn avoid a transformer or modify stage and thus reducing number of process spawned. Perform few sample tests in oracle and DS to see which is useful. Also check the plan in bo...

look for locks from iis administration

look for locks from iis administration