Hi Sergey
does that run in SQL2005
Thanks
Nick
>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