TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
SSIS - How to Use FTP Task [Download File from FTP Site]
Let's say we have to download different files from FTP Task. We want to create one package that can take FolderName/FileName.extension as Variable value and then can download that file to our Local Folder.
We can use FTP Task in SSIS to achieve this. Here is step by step approach to create SSIS Package.
To perform a demo , I am using ftp.microsoft.com and we will download readme.txt file from the ftp site
Create Variable "FolderNameFileName" in your SSIS Package of Type String. Provide the FolderName/FileName.ext as shown below
FolderNameFileName =" /softlib/readme.txt"
Bring FTP Task to Control Flow Pane and Configure as shown below
Once you run package, package will read Variable value for Folder and File and download the file to Destination Folder.
SSIS Configuration can be used to set the value of variable or we can set the value of variable in SQL Server Agent where Package will be scheduled.