Microsoft® SQL Server™ 2005 Integration Services Step by Step
by Hitachi Consulting Paul Turley Joe Kaspizak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman
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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access