Execution properties - Data360_Analyze - Latest

The "Execution" prefixed property values are derived from the start time of an execution of a data flow, or part of a data flow.

When running a data flow from a scheduled task, the execute time will be the time when the data flow actually begins executing. Therefore, if multiple data flows are being run by a single scheduled task, the execution time may be different for each data flow. To get a consistent value across all data flows run by a scheduled task, use the "Run" prefixed properties.

When a data flow, or part of a data flow, is run outside of a scheduled run, for example from the data flow Designer, the property values will be based on the time that you clicked the run button.

The "Execute" prefixed properties are not visible on all data flows. You can use the values in expressions, but in general you should not explicitly set values for these properties, as the values will be automatically generated by the system.

The values of the following properties are in the local time of the Analyze server, unless otherwise specified.

The Date, Time, and TimeZoneOffset suffixed properties are the ISO 8601 Extended formats of date, time, and time zone offset. The DateTime suffixed properties are NOT ISO 8601 compliant for backward compatibiilty reasons. An ISO 8601 compliant datetime can be created by using substitution expression with the data and time values, for example {{^RunDate^}}T{{^RunTime^}}.

The _PathSafe variants of the properties are all in the ISO 8601 Basic formats. These formats are generally safe for substituting into file paths.