One of the easiest is via the FTP Task. By Eric Johnson 05/17/2010 When designing SSIS packages, you will find that you often have to pull data from many different sources.

If you receive error code 0xFFFD0000 while using the Task Scheduler to schedule running of a Powershell Script, then this post will help you fix the problem.

In the Control Flow you have an FTP Task that is available to your package and we will look at how it is configured. The FTP Task is pretty simple, but you do a have a few options to explore.