Скачать или смотреть 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
http://sqlage.blogspot.com/2015/05/fi...

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
http://www.techbrothersit.com/2014/12...