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.

In This Section

  • 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.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.