How to Download Single File from FTP Site in SSIS Package - SQL Server Integration Services (SSIS) Tutorial

Scenario:

We have an agreement with one of our vendor that they will provide the file on daily basis to us. They agreed to upload a file to FTP Server. We need to build a process that can run on daily basis and download the file form FTP Server to our Local Server.


Solution:

We can use FTP Task in SSIS Package to download the file/s from FTP Server to Local Folder. In this video we will perform a demo how FTP Task can be used for requirement. Items we will learn in this video

  1. How to create an SSIS Package from Basics
  2. How to connection to FTP Server by using Internet Explorer
  3. How to download a file from FTP Server by using FTP Task in SSIS Package
  4. How to use Variables in FTP task to change the Local Folder Path and Remote Path
  5. How to overwrite the file in Local Folder if already exists while downloading by FTP Task


Download a file by using FTP Task in SSIS Package


Related Posts / Videos on FTP Task / Script Task