Viewing database source and target data
When debugging a map that uses database sources or targets, you cannot view the database source or target data in the Map Designer by selecting Run Results from the View menu. Because the data retrieved from a database for an input or written to a database as an output is a snapshot of the data at a given time, it is not available to the Map Designer after the map runs.
However, you can use Backup settings to capture the data retrieved from or written to the database for debugging purposes.