I did receive this error today. But not sure where can i specify or change the maximum value. Can you please help ?

In Properties option from toolbar, i found General, Global Variables, Logging, Advanced. But don't have any option to change this max value. Correct me if i am wrong. We are new to this kind of error.

Thank you.

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump

Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft JET Database Engine (80004005): Invalid argument.)

Step Error code: 8004206A

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:0