Restarting Packages with Checkpoints

If you’re like most other information analysts and you update your data warehouse every night, this feature will be of much interest to you. After having set up logging for your packages, every morning you’d be checking the logs for the last night’s update process to see how the update went. You usually expect that the update process has been successful, but what if the update process has failed? You will have to rerun your package during the daytime—and I know you wouldn’t be happy about this, because doing this work during business hours involves some serious implications. Your users will not get the latest updates and will experience poor performance of the database server while you rerun the update process. ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.