SSIS Tutorial Part 96-Download Only Current Day Files from FTP Server by using FTP Task

SSIS FTP Video 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.

How to Create an SSIS Package from Basics
How to Create Variable and Write expression on variable to Get Current Day Files from FTP Server
How to use Variable in FTP Task to download Current Day files to Local Folder in SSIS Package

Link to the blog post for this video

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[anupbhimineni]

Amir!!! This is genuinely a god-level training man! Glad that you are explaining everything in detail in every video! Thank you very much for helping.

[shubhambisht]

You are doing great job sir I cracked Interview with this help thank you so

[anlyq]

I was able to get this setup on 2008 R2.
Thanks.

[anderschristoffersen]

Much appriciated, you saved me a bunch of time developing a script task;-)

[qaisarali]

Thanks Amir i have question how to download the latest uploaded file in the FTP ?

[srikanthreddy]

Thanks Amir.. You saved me every time I needed help.. :-)

[MrJos]

what is that check mark passive mode on ftp?

[mikemarsten]

Any way to do this based on the timestamp of the file?
In my case, the filename does not contain the date.