We use SQL 2005. I have a query written in SQL that I would like to set up as a job that pulls the data into an excel file and "drops it off" on an external FTP site. Ideally the file name would change dynamically by including the file-drop off date (getdate()) before the extension when it gets placed on the FTP site itself (ie data110608.xls)
I've looked into SSIS packages and the FTP connector, but can't connect the dots. Can anyone point me in the right direction?