SQL Server Performance

Fail package on first error check box

Discussion in 'SQL Server DTS-Related Questions' started by CanadaDBA, Oct 5, 2005.

  1. CanadaDBA New Member

    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

Share This Page