If you are using dts and using a transform task object, you can go to properties then options then set max error count. When I want to ignor bad rows I...