My question is if and how to exclude the first part of the flow.
(of course without explicitely adding all datasets to be build inside the scenario.)
I have the following situation. Because of company policy, all data source files are automatically removed every night. (Company policy is that all data should be located inside SQL servers and not in external files).
I do have a project flow, which consists of 3 different source files, namely:
My idea was to sync all three file to a SQL connection.
I do want to have a scenario that runs daily, to calculate the complete flow (data set Result in attached project flow).
How should/can I setup this to acomplise the following situations:
I did experiment with the advanced settings for the rebuild behaviour to set this to "explicit" or "write-protected", but if the files are not present this caused the build-all to fail.
I hope this is clear.
the SQLServer datasets right after the sync recipes should be the ones with the rebuild behavior set to explicit, and their rebuild should be triggered by scenarios with triggers "on dataset change" listening on changes in the input folders or uploaded files datasets.
Or as suggested in the other reply, the first zone moved to a separate project, and the SQLServer datasets after the Sync exposed to the project containing the daily flow