Thursday, October 15, 2009

Restarting SSIS Packages without processing ALL the records over again

Here is a link to a little-known solution to a common problem.  Every time I have restarted a SQL SSIS package in the past that performs transformations on records, all the records get processed over again. 

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
Here is the link:
Restarting SSIS Packages with Checkpoints

While this article uses SQL 2008 as an example, SQL 2005 also employes this same feature.

No comments:

Post a Comment