Best way to make a txt from a query from SQ Server automatic once a week in Visual Studio.

Question

I need to make a txt and put it in a FTP server every week and it has to be automatic. So there are many options here.

I can make a windows service that execute the process every week(My 1th option I think..).

I can make a .exe made it run with a Task Scheduler every week.

I can make a dts with a job (This does not work forme as I dont have the tools for running Integration Services).

What else do you think can be better?.

Tanks