Upload SQL XML file to FTP
I had a question about uploading an XML file generated by a SQL server statement to an FTP account.
For example, i have put together a stored procedure that runs a SQL statement and writes to a file that runs each day as a Schedule Job using SQL Server Agent.
Now the last thing i need to do is to be able to upload the outputted file to an FTP account but i'm not entirely sure how to go about doing this. I have looked into Windows scheduler and also Command Line tools but would prefer asking the professionals ;)
Any ideas anyone?