This article describes how to pass two date values to a node, where the node is connecting to a database table. For example, if you want to extract data from date 2019-06-01 to date 2019-07-02, where the date values are variable. (If the dates are fixed, they can be hard-coded).
STEPS
When the dates are to change on each run, set the SQL to use textual substitution property references, for instance, "where dt < {{^EndDate^}} and dt > {{^StartDate^}}" and then have StartDate and EndDate defined as run properties, per the screenshot below.
Then you'll need to set the run properties upon executing the data flow, or when configuring it to run in a schedule.
FURTHER READING
We recommend reading the Help sections dealing with properties, how to reference them and the different types of properties. You can find that information here: Run Properties
Comments
0 comments
Please sign in to leave a comment.