SQL Server Version: 2005 Enterprise
Operating System: Windows 2003 Standard
Tool: SSIS

I need to grab an ftp file off of a mainframe server where the filename
changes. There is a set part and then a run sequence number appended.
The file name has this format:

E12345.R23456

The E12345 will always be the same - but the R##### will change with
each run. It will (to the best of mine or anyone elses knowledge
always increase - but at some point it would reset after the 5 digit
number has been exhausted). I can also use the date - as we will
always be grabbing the most current file.

Was wondering if anyone else had tackled this - and had some good ideas
about how to approach this. Seems like I am going to have to write
some code to plug into the ftp task - but I may be missing a better way
to handle this.

Thanks,

Matt