I need help writing an SSIS package in SQL Server 2008 R2.
The package needs to run a query, and then place the query results in a .CSV file.
Once the .CSV file is created, it needs to be saved to a specific folder.
After the file is saved in the folder, it needs to be FTP'd.
How can I do this?
Thank you in advance,