My goal is to write error records from both source and destination into one file.
Currently, I'm encountering
Warning: The process cannot access the file because it is being used by another process.
PS: As I explore this feature, I can write these error records into two separate files.
Instead of defining two flat file destinations, define just one and union the error outputs to it.