It would be very useful if we could setup a project variable which refers to the Execution Id (same setup as for e.g. the environment) - so without having to query the TimeXtender Repository DB.
We need this ‘Execution Id’ since we’re calling an ADF pipeline to extract data into a Landing Zone DB. We want to pass the Execution Id to the ADF pipeline as a parameter (through a record in a parameter table), so the ADF pipeline can add the ‘execution ID’ as an extra column in the extracted data.
Like this we’re sure that during execution of the TX execution package only the data requested by this package is being loaded from the Landing Zone DB.
