Hi @Dazler 

You can configure the "Export Sets" for file transfer on MID Server path. 

Create a Export Definition ( What data to export , you can select the columns)

Create a Export Target ( MID Server Name and Path configure )

Create a Export Sets ( configure the export definition & target here along with fileName & Format )

Refer my reply here :

https://www.servicenow.com/community/developer-forum/how-to-export-txt-file-in-midserver-folder/td-p...

Please mark helpful and correct answer if it helps