Chapter Summary

  • When you run packages in the BIDS package designer, the debug environment will show the execution status of tasks, row counts of transformations, and execution results.
  • The control flow includes flexible precedence constraints to handle success, failure, and completion workflows and more complicated expression and logical AND/OR precedence. In addition, event handlers give you the ability to run processes when conditions that you have defined are met.
  • The data flow allows routing of failed rows out an error path and includes data viewers that give you the capability to observe the data during execution as you are developing a package.
  • By using breakpoints during package debugging, you can pause a package during execution to observe package state information, so you can troubleshoot potential problems.

< Back     



© Microsoft. All Rights Reserved.