We help IT Professionals succeed at work.

Receive Files with particular name from FTP server using SSIS

Samoin
Samoin asked
on
113 Views
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.
Comment
Watch Question

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

Commented:
>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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Megan BrooksSQL Server Consultant

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

Author

Commented:
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.

OR

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.