Debugging Packages

Business Intelligence Development Studio and SSIS Designer include tools and features for debugging the control flow and data flow in a package, and for debugging the scripts in the Script task. Using these tools, you can set breakpoints on a package and its tasks and containers and then view information about the package in debug windows. You can also attach data viewers to transformation and source outputs. This allows you to see data as it moves through the data flow, and view progress reports that describe the control flows and data flows during package execution.

The following table lists topics in this section.

Topic Description

Debugging Control Flow

Describes how to debug a control flow using breakpoints, debugging windows, and progress reporting.

Debugging Script

Describes how to debug scripts in the Script task.

Debugging Data Flow

Describes how to debug a data flow using data viewers and progress reporting.

See Also

Other Resources

Creating Packages in SSIS Designer

Help and Information

Getting SQL Server 2005 Assistance