Thank you for the suggestion, Johan.
I’ve spent some time trying to integrate the metadata Injection step into my solution (never used it before), but I’m having problems getting it to work.
My idea was to create a single template transformation that is responsible for joining all the source files (11 in total) – like the ones above, and a second transformation responsible for injecting the meta.
The problem I seem to be having is that I can only inject data for all the joins. When I try to inject data, for let’s say, 2 files (a single join), an error is thrown. It seems to want me to inject all files.
Here’s an example of my injection trans, I feel that my approach might be all wrong.
Any assistance with this is very much appreciated.