You can indeed only choose one option.
If you have multiple destinations for your files, you need to get it in the source query (store it alongside in the table?).
A variable will be no good here.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP