Understanding Package Execution

The BIDS environment is not only conducive to implementing elegant data workflow packages but it also has a large number of features that allow you to understand the implications of package execution.

The most basic of these tools are the Package Explorer view, the package Progress window view, and the design surface itself. When you execute packages in BIDS, all of these areas dynamically reflect a large amount of important information about each step in the package as it executes. The Package Explorer view shown in Figure 9–1 lists all the objects associated with the DataCleaning sample package.

Image

Figure 9–1. ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.