I would like to confirm that it is possible to do the following with SQL Server.
I believe that using DTS from within SQL Server I will be able to:
Schedule a query to run automatically
Export this query to a CSV text file or XML file
FTP this file to another machine
If anybody has some more info on the specifics of doing this I would be grateful.