jump to navigation

SQL Server Integration Services (SSIS) – Checkpoint Restart-ability January 27, 2009

Posted by Arshad Ali in SQL Server Integration Services, SSIS, SSIS 2008.
trackback

Checkpoint Restart-ability

Normally ETL operations are very complex in nature and time consuming process as it often deals with millions of records while pulling it or doing transformation on it. Now even if a package fails in middle of its execution; on next execution it will again start from the begining, repeating all the tasks completed in last run.
SSIS provides Checkpoint restart functionality which simplify the recoverability of packages that contain complex operations and can provide significant time saving because the package does not need to reprocess all of the tasks prior to the checkpoint and will start from last point of failure.
Refer this link for more details.
http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part3_p1.aspx

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: