Summary
You’ve learned lots of techniques for debugging and optimizing your packages in this chapter. While learning these techniques, you learned the internal working of Integration Services and saw how it allocates resources at run-time to different components on the basis of execution trees. The chapter discussed troubleshooting your packages using various features such as breakpoints, precedence constraints, and data viewers. You also worked with breakpoints in a Hands-On exercise to see how variable values are changed during execution of a package.
In the performance section, you learned how to manage memory allocation to data buffers and the types of components that work on the data in the same set of buffers while others force the data ...
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.
