How to modify source query dynamically at runtime

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.