When I run this bulk insert embedded in a stored procedure and as a scheduled sql job after my first "bad data in one field" will fail the job

When I run this via query analyzer it reports in the result pane that there was a bad record but the rest of the records are loaded without aborting the load.

Any ideas????

BULK INSERT CARECLMTC_WRK FROM 'G:\CARESTAT\H7TCLMTC.DATA' WITH
(BATCHSIZE=1000, TABLOCK, MAXERRORS=10, DATAFILETYPE='char', FORMATFILE='E: \scripts\Load_CARECLMTC.fmt')