SSIS - How to Use FTP Task [Download File from FTP Site]

Scenario:

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.

Solution:

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

Step 1: 
Create Variable "FolderNameFileName" in your SSIS Package of Type String. Provide the FolderName/FileName.ext as shown below

FolderNameFileName =" /softlib/readme.txt"


Step 2: 
Bring FTP Task to Control Flow Pane and Configure as shown below


 Final Output:
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.

6 comments:


  1. Great blog !It is best institute.Top Training institute In chennai
    http://chennaitraining.in/oracle-dba-training-in-chennai/
    http://chennaitraining.in/sql-server-dba-training-in-chennai/
    http://chennaitraining.in/teradata-training-in-chennai/
    http://chennaitraining.in/sap-hr-training-in-chennai/
    http://chennaitraining.in/sap-fico-training-in-chennai/
    http://chennaitraining.in/sap-abap-training-in-chennai/

    ReplyDelete
  2. The best piece of utilizing such a help is that you can transfer files paying little heed to their arrangement.transfer large files

    ReplyDelete
  3. None of the screenshots display :-(

    ReplyDelete
  4. Welcome To Techbrothersit: Ssis - How To Use Ftp Task [ File From Ftp Site] >>>>> Download Now

    >>>>> Download Full

    Welcome To Techbrothersit: Ssis - How To Use Ftp Task [ File From Ftp Site] >>>>> Download LINK

    >>>>> Download Now

    Welcome To Techbrothersit: Ssis - How To Use Ftp Task [ File From Ftp Site] >>>>> Download Full

    >>>>> Download LINK bs

    ReplyDelete
  5. Gujarat Secondary and Higher Secondary Education Board (GSEB) Going to Condected Secondary School Certificate (SSC) Final Exam 2023, This GSEB Recently Announce SSC Final Exam Date Sheet 2023,Gujarat Matric Question Paper Gujarat Board SSC Exam Every Year Month of March Conducted, This Exam Every Year More Than 10 Laks of Students Appeared, All Students Pass Marks in Final Exam Good Idea Must Study and Practice Gujarat SSC Question Paper 2023, GSEB also Advises the Guess Paper to be Followed in the Affiliated Schools. GSEB Conducts two main Exams namely Secondary School Certificate (SSC) Exam, Gujarat SSC Model Paper 2023 are very useful in Effective Exam Preparations.
    -

    ReplyDelete