Chapter 7 Quick Reference


Open table as spreadsheet

To

Do this

Create a breakpoint and review variable status in Control Flow

On the Control Flow tab, right-click a task or component and select Set Breakpoints. Select the check box next to the appropriate break condition. Set Hit Count Type and Hit Count if it is necessary. If you would like to create a breakpoint at the package level, right-click the background of the Control Flow pane and select Set Breakpoints. Once you execute the package, the yellow arrow depicts the current location. On the Debug menu, point to Windows and select Locals to open the Locals window. Expand the Variables node in the Locals window to review system and user variables. When you have finished reviewing the status, press F5 to continue execution.

Execute Package Partially

Right-click a task or container and select Execute Task or Execute Container. This allows you to execute a specific item in Control Flow.

Right-click the task or container you would like to skip during the execution and select Disable. Press F5 to execute the package. The SSIS engine executes the package, skipping disabled tasks and containers.

Review data flow between Data Flow components

On the Data Flow tab, right-click a data flow path and select Data Viewers. In the Data Flow Path Editor dialog box, click Add to add a new data viewer. In the Configure Data Viewer dialog box, select the appropriate type of viewer and modify the viewer properties on the second tab. Data will be displayed in the data viewer once the execution reaches the path. Review the data and click the green arrow or Detach in the data viewer window to process execution.

Create a breakpoint and step through code in the Script task

In Control Flow, double-click a Script task. In the Script Task Editor dialog box, click Design Script on the Script page. In the Code Editor, place the cursor on the statement and press F9.

Once execution reaches the breakpoint, press F10, F11, or Shift+F11 to continue execution. Right-click the statement and select Run To Cursor to process statements defined before the line.

Review variables while suspending execution in the Script task

While execution is suspended, go to the Debug menu, point to Windows, and select Autos. Review objects related to the current statement in the Autos window.

Right-click the target variable and select Add To Watch. Watch 1 allows you to track changes in the variable.

Hover the mouse pointer over the object. The DataTip window displays information about the object under the mouse pointer.

On the Debug menu, point to Windows and select Immediate. In the Immediate window, type expressions after the ? command and press Enter. The Immediate window displays the result of the expression in the next line.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net