Debugging Packages
Data viewers are one tool you can use when you need to debug packages. Placed between two tasks, a data viewer shows what the data looks like at that point in the process. If the data looks good so far, you'll know that the problem is occurring further along in your package, or if the data clearly is not correct, you'll know that it happened prior to the point where you are viewing it.
Setting up a data viewer is easy, as you'll see in Exercise 6.3.
EXERCISE 6.3: Debugging Using a Data Viewer
In this exercise, you'll use a data viewer:
- Click the Data Flow tab in SSIS, right-click the line (the wire) between the Derived Column transform and the Excel destination, and then select Data Viewers.
- Data viewers will be selected ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
