I want to enumerate all *.xls and *.csv file. How to fill the Files box? I tried *.xls, *.csv *.xls *.csv *.(xls|cvs) all doesn't work

I don't think you can specify 2 file types in the For each loop container. Perhaps, you could use a *.* and then inside on the container use an expression in the precedence constraints to process only the files you want. I have an example that uses that technique to process files based on a date range; hopefully you will get the idea.

I forgot to include the link to the example I was taking about inmy previous post: http://rafael-salas.blogspot.com/2007/02/ssis-loop-through-files-in-date-range.html

You could do it with regular expressions enumerator:http://microsoft-ssis.blogspot.com/2012/04/custom-ssis-component-foreach-file.html with a regular expression like ^.*\.(csv|xls)$ Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter