If you are using a version of DSP® previous to 6.6, then the [Where Clause Override] setting is incompatible with the "SAP Data Services using RFC" package type.
To use a Where Clause with an "SAP Data Services using RFC" package type in versions prior to 6.6:
Use the "SAP Data Services" package type instead.
NOTE: When using this package type, it is recommended that the Delete Target Table On Build check box be disabled in Collect on the Target Sources page’s Vertical View on the Advanced tab. If the check box is enabled, dspCompose™ will delete every record in the target table during the Final Finish process (during which data posted in the target ERP system by the request is downloaded to tables.)
- Manually insert the Where Clause into the DS job in the Designer.