Filter Files by using WildCard in FTP Task in SSIS Package - SQL Server Integration Services(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.

  1. How to create an SSIS Package from Basics to download files form FTP Server
  2. How to Create Variables for Local Path and for Remote Path with Wildcard
  3. How to Implement different WildCard to filter files for downloading requirement
  4. 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)

How to use WildCard in FTP Task in SSIS Package to Filter Files

Related Posts / Videos on FTP Task / Script Task