angelnjj
asked on
Export to FTP site in .xls format on a schedule (ie every week on Tuesday) from SQL
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?
I've looked into SSIS packages and the FTP connector, but can't connect the dots. Can anyone point me in the right direction?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.