Define input rules to specify which ports to generate and propagate through a dynamic port in the pipeline.
Use the
Input Rules
dialog box to define input rules for a dynamic port, rename the generated ports to indicate where ports occur in a mapping, change the order of the generated ports, and view the results for the rules. You can add multiple rules to include and exclude ports. The Data Integration Service applies rules in the order that they appear in the list.
Open the Input Rules dialog box.
Define one or more input rules for each dynamic port in the transformation. For each input rule, perform the following steps:
Choose the operator and the selection criteria for the input rule.
If you choose the Name selection criteria, specify the criteria details by name or by parameter.
If you choose the Type selection criteria, select the data type of the ports from the list.
If you choose the Pattern selection criteria, select the pattern type, and specify the pattern string as value or as paramter.
Optionally, define the input rule for the last dynamic port in the transformation to include all remaining ports from the upstream transformation.
Rename the generated ports.
Optionally, reorder the generated ports.
Verify the results of the input rules and the input rule settings.