SQL Server Knowledge Sharing Network (@sqlmaster) : package, checkpoint, sql serverhttp://sqlblogcasts.com/blogs/ssqanet/archive/tags/package/checkpoint/sql+server/default.aspxTags: package, checkpoint, sql serverenCommunityServer 2007.1 (Build: 20917.1142)SQL Server Integration Services - think about Transactions and Checkpointing?http://sqlblogcasts.com/blogs/ssqanet/archive/2008/04/07/checkpointing-in-ssis.aspxMon, 07 Apr 2008 06:21:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:9278ssqa.net0http://sqlblogcasts.com/blogs/ssqanet/rsscomments.aspx?PostID=9278http://sqlblogcasts.com/blogs/ssqanet/archive/2008/04/07/checkpointing-in-ssis.aspx#commentsTransactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I&#39;m covering this important task for the sake of newbie &amp; junior DBAs, also the similar question was...(<a href="http://sqlblogcasts.com/blogs/ssqanet/archive/2008/04/07/checkpointing-in-ssis.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=9278" width="1" height="1">sql serverbest practicesssissetuppackagecheckpointbolcommitrollbackdtsssis packagetransaction