How to modify query parameters dynamically at runtime

How to modify query parameters dynamically at runtime

The source entity and query parameters are available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [Sage].[QueryParameters]. This is the property containing the query parameters.
  • Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.