Chapter 10. Auditing and Logging
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Load Data
Design control flow.
Implement control flow.
Configure and Deploy SSIS Solutions
Troubleshoot data integration issues.
Implement auditing, logging, and event handling.
Even in automated data management solutions, errors can and eventually do occur. Not every potential problem can be predicted, and not every contingency can be prepared for in advance. It is therefore impossible to prevent failure altogether, but there is a lot you can do to significantly reduce the probability of failure.
As long as it is possible to anticipate a problem and either prevent it from occurring in the first place (for example, by checking for the existence ...
Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 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.
