SSIS Tutorial Part 94- Filter Files by using WildCard in FTP Task in SSIS Package - SSIS Tutorial

In this video we will learn how to use the WildCard to filter the file names from FTP Server. Wildcards are really helpful to choose the files according to different criteria.

How to create an SSIS Package from Basics to download files form FTP Server
How to Create Variables for Local Path and for Remote Path with Wildcard
How to Implement different WildCard to filter files for downloading requirement
Understanding WildCard

*.* Choose all files by using this wildcard in TFP Task

FileName*.* Provide some part of file name and choose all types of files

*.txt All files with .txt extension only

*_*_.* All files which has _ in their name twice

*_??.txt All text types file which has two characters after _ ( underscore)

Link to the blog post for this video

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

[ChintanDave]

@TechBrothersIT -- Can we connect SFTP server with this FTPTask or not ?? If no then what is the alternative for the same. Awaiting for reply ASAP.

[lmeza]

No matter how I put the wildcard character (*) I always get "Illegal character in path" error, any idea what I am doing wrong?

example:

[parimal]

Thanks for nice video
But what about same file name with different dates