Summary
This was an absorbing chapter, as you’ve worked through various advanced features provided in Integration Services to enhance the service quality of your packages. You’ve worked with logging and log providers and have enabled logging for a package in the Hands-On exercise. Then you worked with transactions and configured your package to use transaction to handle three different kinds of scenarios for processing transactional data. You also used checkpoints to restart your package from the point of failure and learned about the effect of using transactions on checkpoints. Later in the chapter you extended the Contacting Opportunities package to create personalized e-mails using variables and property expressions. In the last Hands-On exercise, ...
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.
