We help IT Professionals succeed at work.

Receive Files with particular name from FTP server using SSIS

Samoin asked
Last Modified: 2017-04-24
I'm trying to setup a FTP task with SSIS that will download the file with a specific name. The issue is that the filename is dynamic, for example today the file name would be

sample_20170419.txt and tomorrow that will change to sample_20170420.txt.

how do we achieve this using SSIS? Any help will be appreciated.
Watch Question

Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

>Any help will be appreciated.
Well in that case, off the top of my head.
  • ForEach File Loop, loop through a folder.
  • Add logic somewhere that matches each file in the loop to your custom logic, setting the result to a variable defined as bit/boolean.  Off the top of my head you may even be able to add this logic in the Loop in a textbox along the lines of 'Files to Compare'.  If that is correct the disregard the green arrow thingie below.
  • Precedence constraint (aka green arrow) from above line, when bit/boolean variable is True, to your FTP task when uses that file variable.
Unlock this solution and get a sample of our free trial.
(No credit card required)
Megan BrooksSQL Server Consultant

Yes, use an expression. That's what they are there for.


The solution provided by expert did not worked.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.