My DTS package fails on the first error. Where can I
increase this, to say, accept the first 100 errors or
accept all of them? Can I send the rejects to an error
file? Thank you. Carl.

This is how you do it:
In BOL, Tasks That Transform Data topic:
1. On the Data Transformation Services (DTS) design
sheet, double-click a Transform Data task or Data Driven
Query task. You must have your source and destination
connections defined before configuring a Transform Data
task.
2. Click the Options tab.
3. Under Exception file, in the Name box, type a file
path for the text file you want to use as an exception
file, or click the browse (...) button to locate the file.
If you enter a file that does not exist, the file will be
created when the step associated with this transformation
task is run.
4. Optionally, if you want to use the Microsoft® SQL
ServerT 2000 data pump exception file options, then under
File type, clear the 7.0 format check box and select the
exception files you want to generate.
5. Under File format, select any additional options
for the exception file.

Just a quick question !

I found this post helpful, but my package raises a
different error when the pump executes.

The number of failing rows exceeds the maximum specified.

How can I increase teh maximum specified by SQL Server.

What does DataMovement - Error count 1 mean in the pump
options properties.

Any help in this regards is appreciated.