How to modify source query dynamically at runtime
The source object, query and parent are available in the data flow properties list. Follow these steps to set up an expression:
- Right-click on the data flow canvas and select the Properties menu.
- Scroll down and find the property named like [QuickBooks Source].[ObjectFilter]. This is the property containing the query.
- Scroll down and find the Expressions property. Set up an expression to modify the query dynamically.