Fail package on first error check box | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Fail package on first error check box

I have a DTS that imports from a text file into a table. I have set the "Max error count" under Options tab in the "Transform Data Task Properties" to 3. I also checked "Fail package on first error" under Logging tab in "DTS package properties". The question is that what happens if the 1st or 2nd or 3rd error occurs? Will the package fail? Or it won’t fail until the 4th error occurs? Thanks, CanadaDBA
]]>