Thank you! Never used Multiphase Data Pump before so was a great introduction. Very interesting object! Also the article made me look at things I overlooked before, great.
BTW, the error count before failure is (fairly?) exposed, I use it for a regular data pump and the Disconnectded Edit allows to enter a larger number manually.
The problem I am having is that DTS does not fail on data type mismatch, but simply inserts NULL if say a nullable numeric column gets a char. If anybody knows how to fix this please send me an email: email@example.com. Thank you in advance.