Need Sql Server Export To Excel and Upload File To FTP Server Daily. I have the SQL Query and theFTP credentials. Must run a query every night from jobs updates between midnight and day before, everyday, export it to excel and send to external FTP site. SQL server 2008 R2 on Windows Server 2008R2.
40 freelancers are bidding on average $111 for this job
Hi, SQL and .Net Web Applications expert here. Please have a look at private message for my portfolio and similar work done. Looking forward to hear from you. Thanks
Hello, I have already done the similar thing. I can create an application in C# or C++ builder or Delphi for this purpose. Please send the detailed specification (part of db schema and excel file sample).
Should be pretty simple to do. I'd set up a job in SQL server to dump the data from the query out to XLSX using SSIS, and then run a batch script to ftp the file over.