An option might be to extract the file to a folder called Extract. Then you can go with a for each loop to that folder and pick up the file there. No variables or output needed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP