How to modify the source dynamically at runtime

How to modify the source dynamically at runtime

The source list or query 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 [SharePoint Source].[InputList]. This is the property containing the input SharePoint list.
  • Scroll down and find the property named like [SharePoint Source].[InputQuery]. This is the property containing the CAML query.
  • Scroll-down and find the Expressions property. Set up an expression to modify the above properties 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+.