I'm trying to use the Bulk Insert Task in DTS and the max errors setting
appears to default to 10. I need it set to 0. There doesn't appear to be a
way to change that in the Bulk Insert Task window in DTS Designer. Does
anyone know how to change the default for max errors? If not, would the next
best option be to create a stored procedure with the exact bulk insert syntax
I need and then execute that stored procedure using an Execute SQL task?

Thanks,
Hari

Hmm, indeed, never noticed this before. Your alternative option will always
work, so I would go for that one.

Alternatively, setting the batch size for the bulk insert task to 1 will
have it stop after the first error occurs... but this will undoubtly come
with a severe performance penalty.