When using the Test window, pay attention to the following:
The Test window alerts you to data-type
mismatches that cannot be resolved automatically.
Use the buttons at the bottom of
the Test window to scroll through the Source rows. Examine the values
that display in the Target pane and verify that you have properly defined
your reformatting formulas.
Use the Test window to verify your
mappings and to see if your formulas, functions, and user variables are
returning the expected values.
Use the Step Result tab to monitor
the step flow for each source row.