Is there a way to force a DTS to move to a new record and attempt to insert
it in a table if it encounters records that violate a constraint? Or do not
fail it, instead just ignore all records that violate the constraint and
insert all other records that do not?

Thanks for your help,
Leo Selmani

I have not done any systematic work on this, but I have found that you can
get DTS to just skip errors by setting the Max Error count (in the options
tab of the data transform). You can also write the error and the source data
to text files using the Exception file and unchecking the 7.0 format and
checking the source (and may destination) error rows.

Some errors still don't work (if I recall right). I haven't tried this, but
I understand that you can use multiphase datapumps. You have to set the
setting on the Data Transformation Services folder in enterprise manager.

In your transform, you create a transform of either Insert Failure or
Transform Failure in the Phases filter. You have to uncheck the fast load
checkbox (if I recall right).

You are on your own from here.
--
Russel Loski, MCSD.Net


[quoted text, click to view]