Chapter 13. Troubleshooting and Performance Tuning
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Implement data flow.
Load Data
Implement control flow.
Configure and Deploy SSIS Solutions
Troubleshoot data integration issues.
This chapter first looks at the various capabilities in Microsoft SQL Server Integration Services (SSIS) for debugging packages during development and how to troubleshoot errors during production execution. The second lesson focuses on good package design as a foundation for good performance of your packages. To make the right performance design decisions, you need to understand the performance architecture of SSIS and the techniques that enable you to maximize the utilization of system resources such ...
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.
