SQL Server Performance

loop through certain files

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 11, 2007.

  1. fmardani New Member

    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?
  2. ranjitjain New Member

    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

Share This Page