For example, you want to remove the leading spaces from the string columns in a table and write the output of the string data along with the data for all other columns to the target. In an Expression transformation, you create two dynamic ports. You configure input rules to include all string data in one port and to put all remaining date in the other port. You choose the

Include all remaining ports

option for the last dynamic port.

The following image shows the dynamic ports String_Ports and Remaining_Ports in the Expression transformation: