How to Download Only Current Day Files from FTP Server by using FTP Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

Scenario:
Our vendors upload the files to FTP Server on daily basis. They upload the files for each day and have date added to each file. We want to create an SSIS Package that runs every day one some schedule and download only the files which are loaded for current day date.

Solution:
To download the files for Current day , we can use FTP Task and build our wildcard by using expressions.
  1. How to Create an SSIS Package from Basics
  2. How to Create Variable and Write expression on variable to Get Current Day Files from FTP Server
  3. How to use Variable in FTP Task to download Current Day files to Local Folder in SSIS Package


 Download Only Current Day Files from FTP Server by using FTP Task in SSIS Package



Related Posts / Videos on FTP Task / Script Task

2 comments:

  1. SSIS package with SFTP is there any video you have,actually i need to download a file from SFTP server.
    In FTP server i am able to download by following your video but SFTP, i think you didn't uploaded.

    ReplyDelete
  2. and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too

    vidmate

    ReplyDelete