In the previous recipe, you retrieved filenames filtered by name and extension using the Foreach File enumerator of the Foreach Loop container. Sometimes you need more precise filters. For example, you might need to retrieve files with a larger size than a predefined value. You can get the collection of the filenames that satisfy your custom criteria with the Script task.
Execute complex filesystem operations with the Script task
Getting ready
There are no special prerequisites for this recipe, except, of course, SSIS 2016. In addition, you can use either your own text files for testing, or the three text files provided with the code for this chapter (Ch11_03.txt, Ch11_08.txt, and Ch11_10.txt). Note that the length of the Ch11_03.txt...