Now that we have variables in SSIS, you have to set up the script task to be able to use these variables. This works the same in 2005 and 2008, except in 2005 you have to type in the variable name ...

You can also combine tasks with iterative code containers to perform repeated actions. Use the Execute SQL Task Editor in SSIS Designer to make changes to Execute SQL tasks.

If you need to be a little more advanced with your FTP you can write a Script Task that utilizes FTP objects. As luck would have it, setting up FTP in an SSIS script will be the topic of ...

How to create a basic task on Task Scheduler To create a task with basic settings on Windows 10, use these steps: Open Start. Search for Task Scheduler, and click the top result to open the app.