This is a problem in a couple respects:
- Processing time wasted
- Code must check for records already processed
- Additional time is spent maintaining that code and procesing
Restarting SSIS Packages with Checkpoints
While this article uses SQL 2008 as an example, SQL 2005 also employes this same feature.