THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » checkpoint files   (RSS)
  • Microsoft advocates checkpoints - proceed with caution [SSIS]

    In December 2012 Microsoft published a whitepaper entitled SSIS Operational and Tuning Guide which you can download by clicking here. I have skimmed through the whitepaper and it appears to be a compelling read however a couple of sentences caught my eye that I want to draw attention to here. These sentences refer to the use SSIS checkpoint ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 4, 2013
  • Why I don't use SSIS checkpoint files

    In a recent discussion in regard to general ETL best practises the subject of checkpoint files as a means for package restartability came up and I stated that I was dead against using them. For anyone that may care, here is why: Configuring them is distinctly unintuitive (that's a matter of opinion but if you follow the link I'll wager that you ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 10, 2011
Privacy Statement