Chapter 7. Package Reliability
What sets enterprise ETL solutions like SSIS apart from just writing your complete process in a TSQL script is how SSIS handles problems. This chapter walks you through several scenarios on how to trap an error that makes your system go bump in the night without having to receive that call or page. In SSIS, you can develop a package that can self-heal or, at worst, roll back to a predictable state where you can fix things in the morning. If you must get a 4 a.m. call, you will want to be able to fix the problem and re-execute the package without having to worry about your data being in an inconsistent state. This chapter walks you through a number of examples on how to stabilize and make your packages bulletproof.
Get Expert 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.
