Combining multiple conditions—Select And or Or in the Add Type box or enter AND or OR in the Filters box.
The default value is Or. Integration Services applies the filter if the conditions you specify are met. If you select And, Integration Services applies the filter only if all conditions are met.
Determining the order in which the relational data source executes multiple conditions—Enter parentheses around the conditions in the Filters box. How you define ordering depends on the relational data source. Consult the documentation for the relational data source.