DSXchange

What other warnings were logged?

When you say "double" are you talking about 10 seconds becoming 20 seconds, or 1 hour becoming two hours? There is some overhead running server jobs in version 8.5, but it does not scale linearly. So a doubling from, say, 2 seconds to 4 seconds might be anticipated, while a doubling from 1...

That suggests that your data may not actually be encoded using GB2312 or, perhaps, that you are using an incorrect variant of GB2312.

The easiest way is that a Type 1 directory contains a hidden file .Type1 whereas a Type 19 directory does not.

Not unless you happen to have mentioned the name of the shared procedure in the description field.

Read what the error message is telling you. Firstly, it's at offset 0 - that is, it is occurring at the beginning of the file. Second, the value it couldn't handle is "ID". Given that that's also the field name, do you think it might be probable that you have omitted to set the "First...

Assuming that projects are on the same system, or even that they can see the same directory, then project A's sequence could create a file that project B's sequence is waiting for. Project A waits for the file to disappear as soon as it starts; project B deletes the file as soon as it finishes.

This link will prove informative about the naming.

What do you mean by "generic or native"?

Do you need to set "First Line is Column Headings" property to True?

Adding it as a separate line is correct. What was the "different error"?

I've always tried to set MAXFETCHBUFFSIZE as a power of 2, but I can't recall why, Perhaps try it with 16384.

Don't do it in the Transformer stage. Do it in a before-job subroutine (after all you only need to check once). Set ErrorCode to a non-zero value to abort the job. Or handle it in a sequence before even running the job, as suggested.

Can you do a lookup of the error code against an error table in the database?

Is inter-process row buffering enabled? This is mandatory if the Link Collector stage is used.

Use the Administrator client to load this map into memory when DataStage starts. Then re-start DataStage.

Did the file come from Windows? Then the character is likely to be Ctrl-M (carriage return) which you can represent as Char(13). Use a hex editor to find out what this character actually is.