How does SSIS foreach limit two file extensions?

On the forum, you can see users who wantSSISContains the extension names of the two types of files (for example, only CSV and TXT files are required). The default function cannot be completed. Only*.*Contains all files or extension names of a single file.

 

There are twoWorkaroundYou can:

 

1. UseScriptFunction to determine the file extension. For detailed steps, refer:

 

RegEx filter for foreach Loop

 

2. Customizable DevelopmentSSISComponent, developed on the Internet:Foreach file enumerator with RegExYou can filter multiple file extensions ().

 

 

For detailed steps and download instructions, refer:Custom SSIS component: foreach file enumerator with RegEx