InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:06:56 GMT20http://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxAddition to prev post: What would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include a some logic to delete the older snapshots after every step ... right? So that, only the changes are propagated on each run of the ETL.Wed, 14 Jan 2009 12:38:31 GMTvishal.gamjihttp://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxWhat would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include a some logic to delete the older snapshots after every step ... right?Wed, 14 Jan 2009 12:35:27 GMTvishal.gamjihttp://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxThanks for such a clear, concise explanation of this topic. (BTW, I've never rated an article before, so accidentally hit 1 star instead of 5. Sorry, I didn't realize it was a one-click operation. I'll know better next time!)Wed, 14 Jan 2009 10:19:02 GMTG-451588http://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxNice one...Wed, 14 Jan 2009 09:11:29 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxNice article.I think you meant, step A will not be run in one of your last paragraphs.The article hasExecution time will be saved..."As it does not run the failed step"Thanks,SeanWed, 14 Jan 2009 08:35:06 GMTSean Woehrlehttp://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxHi,I have a specific checkpoint problem.Occasionally, the SSIS package that I have scheduled will run through successfully to completion, [b]but will not delete the checkpoint file at the end[/b]. The checkpoint file itself will have success indicators for every step in the package. Therefore the next time the package runs, it will do nothing.This is an intermittent problem. Have you come across this before?Thanks,GrahamWed, 14 Jan 2009 02:23:04 GMTGraham Lee-348559http://www.sqlservercentral.com/Forums/Topic631448-144-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services/65473/">Checkpoints in SSIS</A>[/B]Wed, 07 Jan 2009 07:28:05 GMTDinesh Asanka