SQL Server Performance Forum – Threads Archive

loop through certain files

Using SSIS foreach loop, I am looping through files to get the filenames and pass them on as variable.
How is it possible to loop through the files but only pass the files that do not end with …_Parameters.xml? or loop through only the ones which end with …_Parameters.xml
I think this is to do with the scripting or expression in the foreachloop?
Thanks

---

If you select ForEachloop container task, edit its collection properties.
In that, you will get Enumeration configuration where you can specify the kind of files to loop.
Below that type *parameters.xml

---

]]>