Showing posts with label Restart. Show all posts
Showing posts with label Restart. Show all posts

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.