Learn how to add a single hard-coded row to the return set of a TSQL SELECT statement.

To avoid this, we can just add destination and redirect rows with errors to that destination. Now our data flow looks a little different (see Fig. 3). Figure 3.