See Foreach Loop Container - Foreach File enumerator and http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx


>
>I've created a dtsx package to import a csv file.
>
>The import filename is effectively hard coded into the dtsx package.
>
>How can I make the package pick the oldest file in a folder.
>
>the folder is where incoming csv files will be placed and I want a job to be picking up the files from that folder and processing them before moving the file to a backup location.
>
>Any tips or ideas are welcome
>
>Thanks
>
>Nick