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?
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …