Chapter 7. Debugging Packages

After completing this chapter, you will be able to:

  • Create breakpoints on packages, containers, and tasks in Control Flow and suspend execution at different kinds of events.

  • Inspect the current state of execution, using debug windows such as Locals, Autos, and Watch.

  • Understand progress messages logged on the Progress and Execution results tabs.

  • Partially execute packages by disabling tasks and containers in Control Flow.

  • Set data viewers in Data Flow tasks to preview data between transformation components.

  • Create breakpoints in a Script task and inspect code line by line, using VSA debugging capabilities.

In the past few chapters, you learned how to create a package by using several kinds of tasks and Data Flow components. ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.