Modify output data.

You can modify output data of the current transformation. When you continue the session, the Integration Service validates the data. It performs the same validation it performs when it passes data from port to port in a regular session.

Change null data to not-null.

Clear the null column, and enter a value in the value column to change null data to not-null.

Change not-null to null.

Select the null column to change not-null data to null. The Designer prompts you to confirm that you want to make this change.

Modify row types.

Modify Update Strategy, Filter, or Router transformation row types.

For Router transformations, you can change the row type to override the group condition evaluation for user-defined groups. For example, if the group condition evaluates to false, the rows are not passed through the output ports to the next transformation or target. The Instance window displays <no data available>, and the row type is filtered. If you want to pass the filtered row to the next transformation or target, you can change the row type to Insert. Likewise, for a group that meets the group condition, you can change the row type from insert to filtered.