When you enter a transformation data condition, you can select a specific port in the transformation, or you can select from the following port parameters:
Row type.
Insert, update, delete, reject, or filtered.
Row ID.
Row number passing through the transformation.
Any port.
When you choose <<ANY-PORT>>, you can enter a condition that the Integration Service evaluates for every port in the transformation. Use the ISNULL or ISDEFAULT operator to test for null or error default values.
For best results with port-to-port comparison, use ports that have the same datatype. When you compare ports that have different datatypes, the Integration Service converts the datatype of the upstream port to the datatype of the downstream port before it compares the ports, which might result in an invalid comparison.
