var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: bulk insert scheduled job vs query analyzer
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.
BULK INSERT CARECLMTC_WRK FROM 'G:\CARESTAT\H7TCLMTC.DATA' WITH
(BATCHSIZE=1000, TABLOCK, MAXERRORS=10, DATAFILETYPE='char', FORMATFILE='E: \scripts\Load_CARECLMTC.fmt')