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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement