Don't know if its too late or not but here is an article that shows how to export data to csv from within a sql script.

http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell