In my understanding you can not append/update data in the flat-file from the SINK option, either you have to create/replace the existing file. In your scenario, you can read both files i.e., source and target in the DataFlow --> do data manipulation (update data from the target + add new data from the source) --> sink it to the target file. Hope this helps!
If the above response is helpful, please Accept as Answer and Upvote it. Thanks!